Skip to Content
0

creating procedures is deprecated in modeler perspective view and not supported

Nov 04, 2016 at 03:13 PM

1.3k

avatar image
Former Member

Hi all,

I am new to SAP ABAP ON HANA have completed course from 'SAP LEARNING HUB

While creating 'PROCEDURES' in sap hana studio , even though i am in 'SAP HANA DEVELOPMENT' perspective its giving me error as

"creating procedures is deprecated in modeler perspective view and not supported use the developer perspective to create procedures ".

Is there any Role missing from my user creation or something else needs to be added .

I am working on training server .

i am following below path to use store procedure

1. Project 2. work place 3. Repository Package 4. Stored procedure

PROCEDURE " schema"workplace.":file name :" ( ) LANGUAGE SQLSCRIPT SQL SECURITY INVOKER --DEFAULT SCHEMA <default_schema_name> READS SQL DATA AS

BEGIN

select * from table XYZ

END;

when i activate this its giving me error as "; is misplaced "

Thanks and Regards,

PRasad KRishna NAralkar

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Nov 07, 2016 at 10:21 AM
0

Hi all,

By any chance is there anyone who can answer this question >???

Thanks and Regards,

PRasad KRishna NAralkar

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 09, 2016 at 11:32 AM
0

After select statement, please provide ";" as below:

select * from table XYZ;

Share
10 |10000 characters needed characters left characters exceeded