Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Return a recordset in stored procedure
Hi, I am new to Oracle, so this might be a simple question but I don't
know how to slove it.
I am doing the migration from Sybase ASA to oracle database.
How to return a recordset in oracle stored procedure:
In ASA, we can write the following
"create procedure temp (a int) is
x int;
begin
select x;
end;"
it will return a recordset that has one column and one row with value x
(the local variable in procedure temp);
I need to call this procedure in the java file, therefore the command "return x" seems is not working.
Can someone help me here, thank you very much!
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Jul 19 2000 - 00:00:00 CDT
![]() |
![]() |