Re: Trying to use perl to call oracle stored proc to return an object.

2012-05-14 Thread Charles Jardine
On 02/05/12 17:06, Stricker, Scott (IS) wrote: > All: > > I'm trying to use perl to invoke a stored procedure to return an object. > DBD::Oracle does not support support the return of objects via parameters. It does have some support for fetching object as select list elements. See the POD for DB

RE: EXT :Re: Trying to use perl to call oracle stored proc to return an object.

2012-05-02 Thread Stricker, Scott (IS)
t Stricker 703-561-3671 -Original Message- From: Robert Durgin [mailto:rdur...@texterity.com] Sent: Wednesday, May 02, 2012 12:19 PM To: Stricker, Scott (IS) Cc: dbi-users@perl.org Subject: EXT :Re: Trying to use perl to call oracle stored proc to return an object. Did you specify the

Re: Trying to use perl to call oracle stored proc to return an object.

2012-05-02 Thread Robert Durgin
Did you specify the direction for each parameter? - Original Message - From: "Scott Stricker (IS)" To: dbi-users@perl.org Sent: Wednesday, May 2, 2012 12:06:05 PM Subject: Trying to use perl to call oracle stored proc to return an object. All: I'm trying to use perl to

Trying to use perl to call oracle stored proc to return an object.

2012-05-02 Thread Stricker, Scott (IS)
All: I'm trying to use perl to invoke a stored procedure to return an object. Oracle Procedure is defined as PROCEDURE FetchTrackObjbyID ( p_ID IN TRACK.ID%TYPE , p_TARGET OUT TARGET ) Where p_ID is numeric and p_TARGET is the TARGET object type. When I 'execute', I get DBD::Oracle::st ex