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

3 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

  • Feb 21 at 01:33 PM

    It's an old question but I had the same situation today and I found the SAP Note 2471583 about it.

    In a nutshell, this is caused by a bug in HANA Studio versions 2.3+ and the solution is to use the HANA Web IDE (SAP HANA Web-based Development Workbench)

    Add comment
    10|10000 characters needed characters exceeded