Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / guest
Cause: This error means that a fetch has been attempted from
a cursor which is no longer valid. Note that a PL/SQL cursor
loop implicitly does fetches, and thus may also cause this
error. There are a number of possible causes for this error,
including: 1) Fetching from a cursor after the last row has
been retrieved and the ORA-1403 error returned. 2) If the
cursor has been opened with the FOR UPDATE clause, fetching
after a COMMIT has been issued will return the error. 3)
Rebinding any placeholders in the SQL statement, then
issuing a fetch before reexecuting the statement.
Action: 1) Do not issue a fetch statement after the last row
has been retrieved - there are no more rows to fetch. 2) Do
not issue a COMMIT inside a fetch loop for a cursor that has
been opened FOR UPDATE. 3) Reexecute the statement after
rebinding, then attempt to fetch again.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
RMAN-05017: no copy of datafile number found to recover
if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires
IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created
ORA-26076: cannot set or reset value after direct path structure is allocated
ORA-26032: index string.string loading aborted after string keys
when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly
ORA-26030: index string.string had string partitions made unusable due to:
NZE-28868: Peer certificate chain check failed.
ORA-07497: sdpri: cannot create trace file 'string'; errno = string.
ORA-26079: file "string" is not part of table string.string
ORA-16516: The current state is invalid for the attempted operation.
IMG-02003: 2FF03 - incorrect color histogram feature specification
IMP-00064: Definition of LOB was truncated by export
ORA-26028: index string.string initially in unusable state
ORA-26027: unique index string.string partition string initially in unusable state
