Skip to Content
0
May 30, 2012 at 01:53 PM

Error activating SQLScript

25 Views

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