Re: Executing Oracle stored procedures from Ascential DataStage

From: Tom Best <oracle_person_at_yahoo.com>
Date: Thu, 11 Jul 2002 08:39:36 -0400
Message-ID: <agjqkq$oq6$1@news.bentley.com>

John:

You would probably do this by returning a Ref Cursor.

Look that up in the PL/SQL doc.

Tom Best.

"John A. Wong" <jhwshome_at_yahoo.com> wrote in message news:57bbb3cc.0207101806.912cdc2_at_posting.google.com...
> I am having problems executing an Oracle stored procedure that returns
> row results e.g. via a cursor to a DataStage Input stage. I was told
> by DataStage support that this is possible but they haven't been able
> to tell me exactly how it can be done.
> Has anyone had success with this? I'd appreciate any help, and if you
> can send me a sample of the stored procedure.
>
> Thanks.
Received on Thu Jul 11 2002 - 07:39:36 CDT