Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> pl/sql - help!!

pl/sql - help!!

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

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

How do I issue a create table stmt w/in a PL/SQL block in a stored proc implementation. The syntax for my create table is fine-- it goes 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 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US