Error activating SQLScript

[patrickbachmann]

Hello, I am new to HANA modeling and I have read everything I can find about SQLScript in Hana.  I feel like I have a solid grasp of the scripting language fundamentals however I can't seem to create the most simple script without getting a syntax error.  For example something as simple as this;

DROP PROCEDURE procNameHere

Will fail with the error like this "sql syntax error: incorrect syntax near "PROCEDURE":

The same occurs if I try simply

CREATE PROCEDURE procRecCount(IN matNum DECIMAL(5,2), OUT viewList tt_view)

These are just some examples but I've tried many examples from SAP HANA DATABASE SQL SCRIPT GUIDE and also examples from the video SQLSCRIPT IN A NUTSHELL and always I get the syntax error. I'm wondering if perhaps there's some other underlying problem such as security to execute procedures on our HANA box or some other possible problem. Has anybody experienced this problem?

Thanks!

-Patrick

[former_member184768 · Accepted solution]

Can you please check which user / schema are you logged in.

Please ensure that you are logged in non-SYSTEM user schema and the user has all the appropriate privileges.

Regards,

Ravi

[former_member184768]

Also can you please confirm your HANA DB and client revision no.

Regards,

Ravi

[patrickbachmann]

Hi Ravindra, I have gotten my procedures to work now using SQL Editor underneath my username however I was originally trying to type all this script in the PROCEDURE EDITOR.  Apparently the syntax for the procedure editor visual tool is different.  Would you happen to know if there's any guides on that tool?  Otherwise I guess I have to use SQL Editor.  Thanks!

[former_member184768]

Frankly telling you, I use Notepad / Textpad / Basic text editor to write my procedures. . I had been writing procedures since Oracle 7.3 version and used to basic text editors for a long time now.

Regards,

Ravi

[patrickbachmann]

Ok I have now gotten SQLScript to work directly via SQL Editor, via Procedure editor and via Calc view.  Apparently the examples I was trying to type into the procedure editor were really meant to be typed in SQL Editor.  Anyway, thanks for your help.