File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Oracle Stored Procedure
Joined: Nov 02, 2011
Jan 24, 2013 02:06:39
I am new to oracle stored procedure. I want to know how to pass the list of values ('A','B','C') to oracle stored procedure..?
I used the IN clause (IN(@namedList)) in my procedure. please send me any sample for this...
Thanks in advance...
Joined: Jul 29, 2011
Apr 26, 2013 01:09:38
check it out.,
PROCEDURE Get_emp_names (Dept_num IN NUMBER) IS Emp_name VARCHAR2(10); CURSOR c1 (Depno NUMBER) IS SELECT Ename FROM Emp_tab WHERE deptno = Depno; BEGIN OPEN c1(Dept_num); LOOP FETCH c1 INTO Emp_name; EXIT WHEN C1%NOTFOUND; DBMS_OUTPUT.PUT_LINE(Emp_name); END LOOP; CLOSE c1; END;
I agree. Here's the link:
subject: Oracle Stored Procedure
Call a stored Proc from JavaSript? Is it possible?
How to get a return value from the stored procedure using callable statement
calling stored procedure in oracle which returns a table
writing log to a file from java stored procedure
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013