Hi all,
(Sorry about that last incomplete message, CTRL-E in Eudora sends, unlike
EMACS :) )
I have recently been experiencing errors while trying to update CLOBS.
Oracle Version: 8.0.5
DBD::Oracle Version: 1.06
DBI Version: 1.14
When I attempt to update the clob, it seems to update properly (there are
no error messages in the logs), but when I attempt to select from it in
SQL*Plus, I get this error message:
---------------------------------------------
SQL*Plus internal error state 2132, context 0:0:0
Unsafe to proceed
---------------------------------------------
I have consulted the documentation, which refers me to the following Oracle
errors
---------------------------------------------
ORA-01095: DML statement processed zero rows
Cause: A DML cursor from the OTEX() call processed 0 rows when executed.
Action: Caller can either do a rollback or ignore the message and execute
the rest of the cursors in the cursor array.
---------------------------------------------
and
---------------------------------------------
ORA-01403: no data found
Cause: In a host language program, all records have been fetched. The
return code from the fetch was +4, indicating that all records have been
returned from the SQL query.
Action: Terminate processing for the SELECT statement.
---------------------------------------------
The most mysterious part of this error is the fact that it has only started
to happen recently. We have been putting more load on our server via new
scripts and whatnot, but would that cause this type of error?
Thanks in advance to anyone how can help out,
Jim Spath
PS - I am using ORA_CLOB properly when binding and am only updating a
single row with a single CLOB field in it.
--------------------------------------------------------
Jim Spath Junior Developer
AIM: focaJims Focalex, Inc.
[EMAIL PROTECTED] http://www.focalex.com
617-559-0155 x217 What's your Message?
