| |||||||||||
| |||||||||||
Resource Id Error Posted by pagalreddy (pagalreddy), 10 October 2005 $loOK = false;//------------------------ $GOrgID = $_POST['OrgID']; if (isset($_POST['password'])) { $EnteredPassword = $_POST['password']; } //.............. $testallowval = 'AllowBlankPassword'; print("testallowval =".$testallowval); $curs = ocinewcursor($link); $reqQuery = OCIParse($link ,"BEGIN PKG_CMT_PROCS.GetOrgDetail(:GOrgID,:testallowval,:po_refcur);END;"); print("reqQuery =".$reqQuery); OCIbindByName($reqQuery, ":GOrgID", $orgid,1); OCIbindByName($reqQuery, ":testallowval", &$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; print("curs =".$curs); print("stPasswordNotRequired = ".$stPasswordNotRequired); ocifreestatement($reqQuery); ocifreecursor($curs); WHen I try to print, It keeps giving me Resource Id error. Posted by curtis (curtis), 11 October 2005 You have a lot of custom code references there, so it's hard to pin point the problem exactly. Also, what line is the error on? Give us about 10 lines above and below that line.Posted by pagalreddy (pagalreddy), 11 October 2005 $GOrgID = $_POST['OrgID'];echo $_POST[‘OrgID’]."<BR>"; Line 184 echo $GOrgID; if (isset($_POST['password'])) { $EnteredPassword = $_POST['password']; } $reqQuery = OCIParse($link ,"BEGIN PKG_CMT_PROCS.GetOrgDetail(:GOrgID,:AllowBlankPassword,:po_refcur);END;"); print("GOrgID =".$GOrgID); OCIbindByName($reqQuery, ":GOrgID", &$orgid,1); //&$orgid is the column name OCIbindByName($reqQuery, ":AllowBlankPassword", &$detailname,32); //&$detailname is the column name OCIbindByName($reqQuery, ":po_refcur", &$curs, -1, OCI_B_CURSOR); line 194 ociexecute($reqQuery); Line 196 Ociexecute($curs); Line 197 ocifetch($curs); $stPasswordNotRequired = ociresult($curs, 'DetailValue'); //'true' or 'false' $_SESSION['GAllowBlankPassword'] = $stPasswordNotRequired; ocifreestatement($reqQuery); ocifreecursor($curs); Here is the New code and the errors are Notice: Use of undefined constant ‘OrgID’ - assumed '‘OrgID’' in D:\inetpub\wwwroot\CMT\index.php on line 184 Notice: Undefined index: ‘OrgID’ in D:\inetpub\wwwroot\CMT\index.php on line 184 GOrgID = Warning: ocibindbyname(): supplied argument is not a valid OCI8-Statement resource in D:\inetpub\wwwroot\CMT\index.php on line 194 Warning: ociexecute(): OCIStmtExecute: ORA-01008: not all variables bound in D:\inetpub\wwwroot\CMT\index.php on line 196 Warning: ociexecute(): supplied argument is not a valid OCI8-Statement resource in D:\inetpub\wwwroot\CMT\index.php on line 197 Warning: ocifetch(): supplied argument is not a valid OCI8-Statement resource in D:\inetpub\wwwroot\CMT\index.php on line 199 Warning: ociresult(): supplied argument is not a valid OCI8-Statement resource in D:\inetpub\wwwroot\CMT\index.php on line 200 Warning: ocifreecursor(): supplied argument is not a valid OCI8-Statement resource in D:\inetpub\wwwroot\CMT\index.php on line 204 I mentioned the Line numbers Posted by admin (Graham Ellis), 12 October 2005 I'm a MySQL rather than an Oracle person, so this one's a bit outside my speciality. As Curtis has picked up the baton on this one (thanks, Curtis ![]() This page is a thread posted to the opentalk forum
at www.opentalk.org.uk and
archived here for reference. To jump to the archive index please
follow this link.
|
| ||||||||||
PH: 01144 1225 708225 • FAX: 01144 1225 793803 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho |