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 Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: spam at sporty dot org
New email:
PHP Version: OS:

 

 [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

Pull Requests

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: Sun Dec 22 04:01:29 2024 UTC