Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
ElevateDB Technical Support
»
Support Forums
»
ElevateDB SQL
»
View Thread
View Thread
The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
CREATE PROCEDURE script problem
Fri, Jul 31 2009 3:11 PM
Permanent Link
Michael Fullerton
EDB 1.09
When I run a script starting with these lines I get a 700 error on the
third line but don't understand why. What am I missing?
SCRIPT
BEGIN
CREATE PROCEDURE DELETESCS()
[...]
Fri, Jul 31 2009 6:45 PM
Permanent Link
Fernando Dias
Team Elevate
Michael,
Michael,
EDB uses dynamic SQL for both DML and DDL, so the correct syntax is:
SCRIPT
BEGIN
EXECUTE IMMEDIATE
'CREATE PROCEDURE DELETESCS()
....
.....' ;
--
Fernando Dias
[Team elevate]