Skip to Content
avatar image
Former Member

creating procedures is deprecated in modeler perspective view and not supported

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    Hi all,

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

    Thanks and Regards,

    PRasad KRishna NAralkar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 09, 2016 at 11:32 AM

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

    select * from table XYZ;

    Add comment
    10|10000 characters needed characters exceeded