surya.abhi
New User
Apr 8, 2008, 2:35 AM
Post #1 of 1
(2690 views)
|
|
Passing Boolean value to procedure in PERL
|
Can't Post
|
|
Hi,
My self abhi.
I want to pass Boolean value to Oracle procedure, which is OUT parameter.
$sql="create_grps.tracking_group(rptno=>:newBugNumber,tracking_group_id=>:TRACKING_GROUP_ID,value=>:copy_value,success=>:l_success,errormsg=>:l_errormsg);";
$sth=$BUGDBH->prepare("BEGIN $sql END;");
$sth->bind_param(":newBugNumber",$newBugNumber,{TYPE=>SQL_NUMERIC});
$sth->bind_param(":TRACKING_GROUP_ID",$TRACKING_GROUP_ID,{TYPE=>SQL_NUMERIC});
$sth->bind_param(":copy_value",$copy_value,{TYPE=>SQL_VARCHAR});
$sth->bind_param_inout(":l_success",\$l_success,{TYPE=>SQL_VARCHAR});
$sth->bind_param_inout(":l_errormsg",\$l_errormsg,{TYPE=>SQL_VARCHAR});
Here l_success need to pass as boolean value.
Expecting Early reply.
Thanks & Regards
abhi.
|
MAIN
SEARCH
WHO'S 
LOG 