Re: referring to a temp table in a procedure?

[Quoted] You cannot create the table right?

In PL/SQL, you cannot use DDL (Data Definition Language) commands, such as "Create table".
You can only use DML (Data Manipulation Language) commands (Select, Update, Insert).

It is frustrating, correct?

You have to use a script to create your temporary tables.

Have you considered making some views, that would show only the data that you wanted? Since Oracle is multi-tasking and multi-user, you might create some views, a few generations deep, and finally select only from the last view. You would need to use the front end tool to create the views. (Of course, if you could do that,
you would just create the tables the same way, right.)

Rodger Lepinsky
ADP Systems Partnership

Phone:	204-957-1885
Fax:	204-942-3003

L. Tseng wrote:
>
> I don't know if this is a trivial question but I am hitting
> the wall now. Any help will be very appreciated!!!
>
> What I want to do is
>
> In a strored procedure,
>
> create a temp table;
>
> insert some rows to the temp table;
>
> create a cursor on the temp table;
>
> Loop thru the temp table with the DBMS_OUTPUT;
>
> It seems to me DBMS_SQL is the only way to go but...
>
> Can what I want be achieved? how?
>
> Thank you very much.
>
> Leslie
  Received on Thu Nov 14 1996 - 00:00:00 CET