Home » Developer & Programmer » Precompilers, OCI & OCCI » OCI BIND Error
OCI BIND Error [message #141656] Tue, 11 October 2005 08:32 Go to next message
pagalreddy
Messages: 2
Registered: October 2005
Junior Member
$loOK = false;
//------------------------
$GOrgID = $_POST['OrgID'];
if (isset($_POST['password']))
{
$EnteredPassword = $_POST['password'];
}
//..............

print("GOrgID =".$GOrgID);
$curs = ocinewcursor($link);
$reqQuery = OCIParse($link ,"BEGIN PKG_CMT_PROCS.GetOrgDetail(":$GOrgID",:AllowBlankPassword,:po_refcur);END;");
print("reqQuery =".$reqQuery);
print("GOrgID =".$GOrgID);


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

ocifetch($curs);



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

ocifreestatement($reqQuery);
ocifreecursor($curs);


Its not taking the $GorgID, How to make it take it.
Parse error: parse error, unexpected ':' in D:\inetpub\wwwroot\CMT\index.php on line 192

Please help me
Re: OCI BIND Error [message #142378 is a reply to message #141656] Fri, 14 October 2005 07:19 Go to previous message
Frank Naude
Messages: 4564
Registered: April 1998
Senior Member
I don't think it likes the $ (dollar sign). Can you take it out and try to compile again?

Best regards.

Frank
Previous Topic: OCIBINDBYNAME
Next Topic: What version of ODBC drivers uses OCI API's to connect to Oracle database?.
Goto Forum:
  


Current Time: Sun Jul 12 02:49:39 CDT 2020