Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Return a recordset in stored procedure

Return a recordset in stored procedure

From: <xinhuang00_at_my-deja.com>
Date: 2000/07/19
Message-ID: <8l4rld$2rk$1@nnrp1.deja.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US