Re: Input output binding using DBI

I dont see you executing a stored procedure. I see you executing a select statuement...

Select * from sun_t_attm_temp_posm1d002
[download]

what you probably want to prepare is a PL/SQL block like...

BEGIN
  Par_Reports_Pos.SUN_PRC_AT_I_POSM1D002(?, ?);
END;
[download]

then your binds would change to...

my $retCode;
my $retMsg;
$sth->bind_param_inout(1, \$retCode, 100);
$sth->bind_param_inout(2, \$retMsg, 100);
[download]

$regCode and $regMsg would then be set with the results of the procedure call after you execute.

Comment on Re: Input output binding using DBI Select or Download Code

Replies are listed 'Best First'.
Re^2: Input output binding using DBI by Nesh (Beadle) on Apr 06, 2005 at 00:46 UTC
Thanks for your reply. I had missed the required stored procedure call code. I have corrected that. Even after changing according to your advice I get the error as "bind_param_inout needs a reference to a scalar value at storedproc.pl line 23."	[reply]
Re^3: Input output binding using DBI by mifflin (Curate) on Apr 06, 2005 at 01:50 UTC
Note the difference between your bind_param_inout calls and mine. See the backslash before the variable names in mine? That says "pass a reference to this variable", not the varable itself.	[reply]