Home » SQL & PL/SQL » SQL & PL/SQL » passing string array to stored proc
passing string array to stored proc [message #189461] Thu, 24 August 2006 12:55 Go to next message
techluver
Messages: 16
Registered: May 2006
Junior Member
PROCEDURE GET_EMPNAME( EMP_ID1 IN VARCHAR2,EMP_ID2 IN VARCHAR2, O_RESULT_SET OUT CURSOR_TYPE)
AS
BEGIN
OPEN O_RESULT_SET FOR
SELECT EMPNAME
FROM EMPLOYEE E
WHERE E.EMP_ID IN (EMP_ID1,EMP_ID2)
END;
hi,

Here instead of passing emp_id1 and emp_id2..etc., I would to pass it as emp_Id_string_Array as a parameter to stored proc and use that emp id array in where class comparison.


Can anyone please help me on this with an example?
Thanks in advance.
Re: passing string array to stored proc [message #189464 is a reply to message #189461] Thu, 24 August 2006 13:01 Go to previous messageGo to next message
techluver
Messages: 16
Registered: May 2006
Junior Member
also I when pass empId as string to proc with values "123,122,122" I'm not correct result from the DB.

Re: passing string array to stored proc [message #189497 is a reply to message #189464] Thu, 24 August 2006 18:41 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://tkyte.blogspot.com/2006/06/varying-in-lists.html
Previous Topic: Call a Procedure from a query
Next Topic: find column name of specific value in a table (200 columns)
Goto Forum:
  


Current Time: Sun Dec 04 10:38:08 CST 2016

Total time taken to generate the page: 0.07237 seconds