Temporary Tables

Hi,

        I am unable to create temporary tables in my stored procedures. I keep on receiving errors when I use terms Create, Truncate, and Drop.

Error message is as follows:

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>

Is it because PL/SQL does not allow these terms ? and if so, how do I get around it. Any help would be appreciated.

Thanks,
Don Received on Thu Dec 18 1997 - 00:00:00 CST