Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Create Table in PL/SQL
Hi,
I am trying to create temporary tables in my stored procedures and I am finding that I cannot create, drop or truncate tables. Is this functionality not available in PL/SQL?
Any suggestion on how I can ? I listed the error message I am receiving.
Thanks,
Don
ORA-06550: line 3, column 1: 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> << close current delete fetch lock insert open rollback savepoint set sql commit <a single-quoted SQL string> Received on Thu Dec 18 1997 - 00:00:00 CST