Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?

Re: DBI problem on AIX/Oracle 10g

by smithers (Friar)
on Jul 25, 2007 at 18:30 UTC ( #628759=note: print w/replies, xml ) Need Help??

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.

Replies are listed 'Best First'.
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.
      Do you have Oracle Metalink support access? If so, lookup support Note: 415637.1. If you are running Oracle 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.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://628759]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (2)
As of 2023-10-04 17:11 GMT
Find Nodes?
    Voting Booth?

    No recent polls found