NewBee - Read Cursor

From: Franck <wesley.saris_at_gmail.com>
Date: 19 Apr 2005 07:50:52 -0700
Message-ID: <74e7fd2c.0504190650.4bd77d62@posting.google.com>

Hi,
I'm trying to call a stored procedure which return records in another stored procedure but can't figure out how to read the result!

---

create or replace procedure TEST(
issue_number IN VARCHAR2,
date_start IN VARCHAR2,
C_RESULT OUT Cv_Types.GenericCurTyp)
IS

oTmpResult Cv_Types.GenericCurTyp;
resultnumber number;

BEGIN PROC1(issue_number,date_start,0,oTmpResult); resultnumber := PROC1 result first record first column value

---

How can I read the PROC1 result (which is a number)?

Thks for help Received on Tue Apr 19 2005 - 09:50:52 CDT