Home » Developer & Programmer » Precompilers, OCI & OCCI » OCIBINDBYNAME
OCIBINDBYNAME [message #141492] Mon, 10 October 2005 08:56
pagalreddy
Messages: 2
Registered: October 2005
Junior Member
$GOrgID = $_POST['OrgID'];
if (isset($_POST['password']))
{
$EnteredPassword = $_POST['password'];
}
//..............
$curs = ocinewcursor($link);
$reqQuery = OCIParse($link ,"BEGIN PKG_CMT_PROCS.GetOrgDetail($GOrgID,AllowBlankPassword,:po_refcur);END;");

OCIbindByName($reqQuery, ":$GOrgID", $orgid,1);
OCIbindByName($reqQuery, ":AllowBlankPassword", &$detailname,32);
OCIbindByName($reqQuery, ":po_refcur", &$curs, -1, OCI_B_CURSOR);
$reqResult = ociexecute($reqQuery);


ocifetchinto($reqResult);

$stPasswordNotRequired = ociresult($reqResult, 'detailvalue'); //'true' or 'false'
$_SESSION['GAllowBlankPassword'] = $stPasswordNotRequired;

ociexecute($curs);
ocifreestatement($reqResult);

Warning: ocibindbyname(): OCIBindByName: ORA-01036: illegal variable name/number in D:\inetpub\wwwroot\CMT\index.php on line 191

Warning: ocibindbyname(): OCIBindByName: ORA-01036: illegal variable name/number in D:\inetpub\wwwroot\CMT\index.php on line 192



Please Help Me
Previous Topic: Re: sqlcxt error
Next Topic: OCI BIND Error
Goto Forum:
  


Current Time: Mon Jul 13 13:37:42 CDT 2020