Home » SQL & PL/SQL » SQL & PL/SQL » Sending List to Oracle Stored Procedure
Sending List to Oracle Stored Procedure [message #663791] Mon, 19 June 2017 08:30 Go to next message
anandneema
Messages: 1
Registered: June 2017
Junior Member
Hello,

I am working on a solution, where I have a requirement to send list from UI to the stored procedure. Since I am new to PL/SQL, I don't know how can I pass list to the stored procedure.

Can some one help me or give me a direction how can I pass complete list to the procedure.

Thanks in anticipaion.

Regards,
Anand Neema
Re: Sending List to Oracle Stored Procedure [message #663792 is a reply to message #663791] Mon, 19 June 2017 08:56 Go to previous messageGo to next message
BlackSwan
Messages: 25476
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Neither SQL nor PL/SQL have any "list" datatype.
A valid datatype must be used; so which is used.
Re: Sending List to Oracle Stored Procedure [message #663793 is a reply to message #663792] Mon, 19 June 2017 09:15 Go to previous messageGo to next message
ThomasG
Messages: 3201
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
An array could be passed to a PL/SQL procedure.

https://www.tutorialspoint.com/plsql/plsql_arrays.htm

The question is whether an PL/SQL Array is supported in whatever the "UI" is written in. (It is supported in the Java client, for example)

[Updated on: Mon, 19 June 2017 09:16]

Report message to a moderator

Re: Sending List to Oracle Stored Procedure [message #663794 is a reply to message #663793] Mon, 19 June 2017 09:45 Go to previous message
Michel Cadot
Messages: 64959
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Another question is whether a cursor is not a better solution than an array if its data come from the database.

Previous Topic: grouping of records
Next Topic: how to calculate column value dynamically
Goto Forum:
  


Current Time: Tue Jun 27 05:40:04 CDT 2017

Total time taken to generate the page: 0.09895 seconds