php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
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: Fri Oct 11 18:01:28 2024 UTC