| ORA-24370 [message #98105] |
Mon, 23 February 2004 04:12  |
Matias
Messages: 1
Registered: February 2004
|
Junior Member |
|
|
I have a “C” program that tries to insert a record into a ORACLE database (9.2) and an error occurs: “SqlCode: -24370 - ORA-24370: illegal piecewise operation attempted ORA-02063: preceding”
Can you help me with this please.?
Tanks
|
|
|
|
| Re: ORA-24370 [message #98106 is a reply to message #98105] |
Thu, 26 February 2004 04:11  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
Hi,
This sounds like a logic error in the program. You will have to debug it to find the exact statement that causes this error; and the data it operated on. Then, post your results here...
Best regards.
Frank
|
|
|
|
| Re: ORA-24370 [message #98162 is a reply to message #98105] |
Thu, 15 April 2004 10:58 |
Mark Kuniansky
Messages: 1
Registered: April 2004
|
Junior Member |
|
|
|
Check (or have your DBA check) your Oracle cursor sharing mode. I had to alter my oracle session "alter session set cursor_sharing=exact" within my program, which generated the same error when running across 2 databases, one oracle 8 and the other oracle 9, using bind variables. The default cursor sharing mode of FORCE was the problem according to our DBA.
|
|
|
|
| Re: ORA-24370 [message #98546 is a reply to message #98162] |
Sun, 26 December 2004 02:21 |
Lake
Messages: 1
Registered: December 2004
|
Junior Member |
|
|
Mark,
Excellent fix - it worked fine. We have an Oracle 9 database writing into an Oracle 8 database via a ProC program, and all the inserts were failing - until your suggestion.
Many thanks,
Lake
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
