OraFAQ Forum: SQL & PL/SQL » Sending List to Oracle Stored Procedure

Home » SQL & PL/SQL » SQL & PL/SQL » Sending List to Oracle Stored Procedure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sending List to Oracle Stored Procedure [message #663791]

Mon, 19 June 2017 08:30

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

Report message to a moderator

Re: Sending List to Oracle Stored Procedure [message #663792 is a reply to message #663791]

Mon, 19 June 2017 08:56

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Sending List to Oracle Stored Procedure [message #663793 is a reply to message #663792]

Mon, 19 June 2017 09:15

ThomasG
Messages: 3211
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

Michel Cadot
Messages: 68641
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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 07:02:50 CDT 2024