Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread CREATE PROCEDURE script problem
Fri, Jul 31 2009 3:11 PMPermanent 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 PMPermanent Link

Fernando Dias

Team Elevate 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]

Image