CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: DBI:
Passing Boolean value to procedure in PERL

 



surya.abhi
New User

Apr 8, 2008, 2:35 AM

Post #1 of 1 (3241 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.

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives