Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

creating temperary table in orcle stored proc

Status
Not open for further replies.

malaikofta

IS-IT--Management
May 23, 2001
1
US
hei, I need to create a stored procedure in orcle, which takes few parameters. Inside the table i need to create a temperary table which stores some calculted data ( more than one row )
Can anyone help me how to create a temp table inside the stored proc which exists within the scope of the stored procedure and destroyed at the end of the procedure. Pls can anyone help with with a small code example
 
Try to use pl/sql table. If you need the data to be referenced from a number of stored procedures you may make it a package variable.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top