Oracle Package Bind Error
Posted by pagalreddy (pagalreddy), 11 October 2005$loOK = false;
$GOrgID = $_POST['OrgID'];
$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);
$stPasswordNotRequired = ociresult($curs, 'DetailValue'); //'true' or 'false'
$_SESSION['GAllowBlankPassword'] = $stPasswordNotRequired;
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
Posted by admin (Graham Ellis), 12 October 2005The 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.
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: firstname.lastname@example.org • WEB: http://www.wellho.net • SKYPE: wellho