Skip to Content
avatar image
Former Member

HANA Express Edition SQLSCRIPT_SYNC not found when creating procedure

Jan 14, 2018 at 12:07 PM | 86 Views

Hello experts,

when I try to create the procedure 

PROCEDURE "wait" 
    (      )
    LANGUAGE SQLSCRIPT SQL 
    SECURITY INVOKER 
    AS 
 BEGIN   
  USING SQLSCRIPT_SYNC AS SYNCLIB;
  IF 1 = 1 THEN     CALL SYNCLIB:SLEEP_SECONDS(30000);   END IF;  END;

in db module of my XSA project, WebIDE is showing the error

in the console.

When I create the procedure in Eclipse for User XSA_ADMIN the procedure will be created successfully.

Thanks for your help

Achim

error.jpg (64.8 kB)
SAP HANA, express edition
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Andy Scott
    Jan 19, 2018 at 10:22 PM

    Hello Achim,

    Developers are aware of the issue, and are working on a fix.

    Unfortunately, we do not have a solution for you now.

    -Andy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Andy Scott
    Jan 18, 2018 at 11:28 PM

    Hello Achim,

    I was also able to create the procedure ok using hdbsql.

    And, when I tried to use webide project to create the procedures, saw the same error.

    I will consults with webide developers and see if they have remedy.

    -Andy

    Add comment
    10|10000 characters needed characters exceeded