Re: Returning a full cursor record from procedure

It occurs to me that maybe I'm asking the wrong question. What I really need to do is return a record set consisting of multiple records to a Visual Basic 5 program. What is the best way to go about doing that?

Thanks again,

Bob

In article <6kenlj$un2$1_at_nnrp1.dejanews.com>,   meyer_b_at_rocketmail.com wrote:
>
> How can I (or can I?) return a complete set of cursor records from a
> catalogued procedure?
>
> Take the following simple proc:
>
> CREATE OR REPLACE PROCEDURE PROC_DEMO_SELECT
> (p_case_id IN OUT NUMBER )
> IS
> CURSOR cur_demo IS
> SELECT CASE_ID, CASE_ENTRY_DATE
> FROM CASES;
> v_case_record cur_demo%rowtype;
> BEGIN
> OPEN CUR_DEMO;
> LOOP
> FETCH cur_demo INTO v_case_record;
> EXIT WHEN CUR_DEMO%NOTFOUND;
> p_case_id := v_case_record.CASE_ID;
> END LOOP;
> CLOSE CUR_DEMO;
> END;
> /
>
> This compiles fine. What I want to do though, is return the entire record
> v_case_record, but I can't figure out any way to put a parameter called
> p_case_record, defined as a RECORD, in the CREATE procedure statement. Is
> there anyway to do this?
>
> If it makes a difference, I want to pass the output of this procedure to
> Visual Basic 5.0 as a record set.
>
> Many thanks to anyone who can help.
>
> Bob
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 26 1998 - 00:00:00 CEST