Re: Create Table with DBMS_SQL problem

Unless you switch to 8i, or get a licence for the Object option of 8.0 there is little you can do other than code the entire use of the table in dbms_sql. Since you (presumably) know the structure of the table this is not too hard, just a bit of a nuisance.

The Object option would be to avoid the temporary table, and create arrays of an object type. When you want to add or change data, you use array processing methods, but when you want to 'report' from the array, you can use the CAST mechanism to 'turn it into' a cursor.

There is an example on my web-site.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Rob Bell wrote in message <3772F6DF.A6018989_at_csc.com>...

>I have a need to do a CREATE TABLE within a stored procedure in Oracle
>8. I did some research and found the DBMS_SQL package and have been
>able to put together the dynamic SQL for my table creation. Problem is,
>when I need to access the newly created temporary table from a query in
>another part of the stored procedure, it can't find the table. At
>compile time I get a message saying that the table name is not a
>declared object.
Received on Fri Jun 25 1999 - 02:58:05 CDT