php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #5767 OCIBind/OCIStmtExecute error
Submitted: 2000-07-24 23:11 UTC Modified: 2006-07-17 08:10 UTC
From: spam at sporty dot org Assigned:
Status: Closed Package: OCI8 related
PHP Version: 4.0.1pl2 OS: Redhat linux
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [2000-07-24 23:11 UTC] spam at sporty dot org 
After speaking with oracle, they claim i am not inserting an integer when doing this.  I was also asked to set an environment variable to ensure i'm using 7 bit ascii.  I can rewrite the function in perl and succeed with it.

---
if(!$stmt=OCIParse($dbh,"delete from mstats where job_num=$jobnum and message_id=to_number(:mid)"))
	return(0);

OCIBindByName($stmt,":mid",&$mid);
foreach ($messageIDs as $mid)
	{
		settype($mid,"Integer");
		print gettype($mid);
		if(validMessageId($mid))
			OCIExecute($stmt);
	}
--

i use the settype to just make sure, as well as the to_number.  php/oracle generates this error.

OCIStmtExecute: ORA-01460: unimplemented or unreasonable conversion requested in [filename and line number]

help!

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-07-25 14:21 UTC] thies@php.net 
please pass 32 fo rthe size in OCIBindByName:

OCIBindByName($stmt,":mid",&$mid,32);

and reprot back!
 [2000-07-25 14:22 UTC] thies@php.net 
please pass 32 fo rthe size in OCIBindByName:

OCIBindByName($stmt,":mid",&$mid,32);

and reprot back!
 [2000-08-04 11:32 UTC] stas@php.net 
reclassify
 [2000-08-04 11:35 UTC] thies@php.net 
user reported success!
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Thu Apr 18 16:01:29 2024 UTC