$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);

What am I doing Wrong ? Somehow its not taking $GORGID as In Parameter and it keep saying.
Warning: ocibindbyname(): OCIBindByName: ORA-01036: illegal variable name/number in D:\inetpub\wwwroot\CMT\index.php on line 197

and If i take out $, and keep only GORGID its not passing in the value.

Please help me

     

The third parameter to ocibindbyname should be a reference to a variable (i.e. start with an &) but that's misisng in that once particular call. I think that's probably what's causing the error - the name is being reported back not because it's the thing that's wrong, but to tell you which of what could be a lot of bind by name calls it's having a problem with.

---