pl/sql - help!!

From: Goldrich <goldrich_at_gateway.grumman.com>
Date: 1997/01/29
Message-ID: <32EFD21B.DC7_at_gateway.grumman.com>#1/1


[Quoted] [Quoted] Can't find the answer to this one in any documentation or books I have.

[Quoted] [Quoted] How do I issue a create table stmt w/in a PL/SQL block in a stored proc [Quoted] implementation. The syntax for my create table is fine-- it goes [Quoted] [Quoted] smoothly when entered at SQLPLUS command line. Same command w/in stored proc produces a syntax error.

 PLS-00103: Encountered the symbol "CREATE" when expecting one of  the following:
 begin declare exit for goto if loop mod null pragma raise  return select update while <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
<a single-quoted SQL string> << close delete fetch lock
 insert open rollback savepoint set sql commit

Email replies would be greatly appreciated as I am posting this via a very unreliable new server.

Thanks in advance. Received on Wed Jan 29 1997 - 00:00:00 CET

Original text of this message