Re: Stored Proc question

Prashant Prabhudesai wrote:
>
> Hi:
>
> I am trying to display multiple records in a stored procedure.
>
> We have a VB/ODBC application which calls the stored proc.
>
> For some reason I am unable to get this working.
>
> Stored Proc :
>
> CREATE OR REPLACE PROCEDURE test_proc
> AS
> BEGIN
>
> SELECT batch_id from batch_info;
>
> END test_proc;
>
> /
>
> ERRORS: This one says INTO missing,
> When I add INTO CLAUSE, The Stored Proc compiles but then It fails on EXECUTE
> ERROR MSG: FETCH returns more than One Row.
>
> Basically I would like to get all the rows when I execute the stored proc.
>
> Any Help is greatly appreciated.
>
> Thanks.
>
> Prashant

This functinality is not supported by ORACLE - you can't return rows from the sp, only variables.

-- 
____________________________________
Oleg Dimerman (olegd_at_oeonline.com)