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

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

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

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

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

Did you specify the direction for each parameter? - Original Message - From: Scott Stricker (IS) scott.stric...@ngc.com 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

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

Thanks for the reply Robert. PROCEDURE FetchTrackObjbyID ( p_ID IN TRACK.ID%TYPE, p_TARGET OUT TARGET ) PROCEDURE is defined with an IN and OUT param. May have also tried it with an in out vs simply an out param and this made no difference. $sth-bind_param_inout(:p_Target,\$p_Target, 20)