-
All,
we're trying to create a procedure which does a select (via a cursor?) and returns the results of this query to a Java program.
Can any help us with this?
The biggest problem is to make the procedure with the correct types, ...
Thx,
Rik
-
-
Hi,
Better to Use a Package.
Declare any Variable as Ref Cursor and then Open that Ref Cusror for any Select Statement.
Create or Replace Package Mypack
is
TYPE EmpCurType is REF Cursor;
Procedure Empname (EmpCur IN OUT EmpCurType,
Id IN Number);
End;
Create or Replace Package body Mypack
is
Procedure Empname (EmpCur IN OUT EmpCurType,
Id IN Number)
is
Begin
Open EmpCur for Select Ename, Job, Sal from emp
Where Empno = Id;
End;
End;
Hope this will Give you the Idea that you are LOoking for.
Thanks.. Qaisar
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|