Creating a procedure to return a select

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

See http://govt.oracle.com/~tkyte/ResultSets/index.html

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

Thx a lot,

looks great.