Home » SQL & PL/SQL » SQL & PL/SQL » Table as Input Parameter (merged)
Table as Input Parameter (merged) [message #216816] Tue, 30 January 2007 10:04 Go to next message
stepthom
Messages: 3
Registered: January 2007
Junior Member
No Message Body

[Updated on: Tue, 30 January 2007 10:33]

Report message to a moderator

Re: Table as Input Parameter [message #216817 is a reply to message #216816] Tue, 30 January 2007 10:05 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
You will need to use dynamic SQL to make the table name variable.
Re: Table as Input Parameter [message #216818 is a reply to message #216816] Tue, 30 January 2007 10:07 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
asked & answered many, many times in this forum.
1) you'll need EXECUTE IMMEDIATE
2) http://asktom.oracle.com has many fine coding examples
Re: Table as Input Parameter [message #216819 is a reply to message #216816] Tue, 30 January 2007 10:07 Go to previous messageGo to next message
stepthom
Messages: 3
Registered: January 2007
Junior Member
Can you point my to a website or something with some documentation so that I can get a clearer picture?

thanks.
Re: Table as Input Parameter [message #216822 is a reply to message #216816] Tue, 30 January 2007 10:25 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
If you are incapable or unwilling to use Google or similar search site, I refuse to spoon feed you clues or answers.

[Updated on: Tue, 30 January 2007 10:31] by Moderator

Report message to a moderator

Re: Table as Input Parameter [message #216823 is a reply to message #216816] Tue, 30 January 2007 10:29 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
Especially when the OP is posting the query in a PL/SQL Experts forum !
Table as Input Parameter [message #216824 is a reply to message #216816] Tue, 30 January 2007 10:32 Go to previous messageGo to next message
stepthom
Messages: 3
Registered: January 2007
Junior Member
Hi


I am attempting to pass a table as an input parameter into a stored procedure. I am not sure what the correct data type syntax is. I have been trying to find a list of all valid parameters types, but with no luck.


When I use the table as an input parameter, will I be able to use it the same way as a cursor?

My goal is to take the input data and insert it into an oracle table.


TIA
Re: Table as Input Parameter [message #216825 is a reply to message #216824] Tue, 30 January 2007 10:35 Go to previous message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
Our zealous moderator would have moved your post in PL/SQL exports before too long, so you didn't really need to post it again.
Previous Topic: Holiday flag in time dimension table
Next Topic: Causes of internal code error :??
Goto Forum:
  


Current Time: Sat Dec 03 08:17:54 CST 2016

Total time taken to generate the page: 0.14406 seconds