|
in reply to DBI problem on AIX/Oracle 10g
Any chance you are passing in undef for $FileId, $DepartmentId or $ScheduleDttm or the wrong data-types expected by Oracle (e.g. alpha char for an integer file or dept id)?
Binding on a null could be an issue with the SQL (need AND DEPT_ID IS NULL for example vs. AND DEPT_ID = NULL).
Connectivity (and TNS_ADMIN) does not seem to be the issue here if your first invocation of CheckTransmissionHist is successful. Good luck. |
Re^2: DBI problem on AIX/Oracle 10g
by hibbarra (Novice) on Jul 27, 2007 at 17:35 UTC
|
No they are all defined, checked them in the debugger. | [reply] |
|
|
Do you have Oracle Metalink support access? If so, lookup support Note: 415637.1. If you are running Oracle 10.2.0.3 then this Note identifies an Oracle bug that matches the behavior you reported exactly with the second execute aborting.
If you don't have Metalink access, try setting your Oracle db parameter CURSOR_SHARING=EXACT (the workaround mentioned in the support note). The note also implies there is a bugfix for this issue. Get your DBA involved.
| [reply] |
|
