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)