temporary tables in oracle

[cba321]

Dear All,

I have created a package having a stored procedure. I wanted to create a temporary table inside the stored procedure.

Can anyone of you help me at the earliest.

Regards,
CBA321

 

[ManjulaMadhu]

if you are asking for the syntax:

create global temporary table test1
( c1 number, c2 number)<on commit delete rows>;

the on commit parameter is optional and can have one of these values : delete rows(this is default) /preserve rows

 

[sem]

If you mean DATABASE table, you need DYNAMIC SQL (e.g. EXECUTE IMMEDIATE). You may also define some package-wide collection type.

Regards, Dima