Answered it myself. I was trying to create the SP via ISQL, which sees a semi-colon as an end-of-file character.
Stored Procs use semi-colons to delimit each statement.
Overcome by using dbaccess to create the SP.
Hi, I'm having trouble creating a Stored Procedure for the first time on a box running Online V5.1 and SQL V4.20.
I can create a s.p. with nothing in it (no statements of any kind), but when I add anything useful, it produces a syntax error on the first line.
e.g. Define a_variable INT...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.