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

Home -> Community -> Usenet -> c.d.o.misc -> Create Table in PL/SQL

Create Table in PL/SQL

From: Donald Fuller <drfuller_at_wsicorp.com>
Date: 1997/12/18
Message-ID: <67bqsr$vr@tomcat.admin.navo.hpc.mil>#1/1

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

Original text of this message

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