how to resolve the sqlcode -501 erroe in db2?
Answers were Sorted based on User's Feedback
Answer / viswa
This is due to the cursor declaration in which the application program has attempted to fetch some data's into a cursor that was neither declared nor opened. So, Always follow DECLARE,OPEN,FETCH,CLOSE while working with cursors.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / avinash
if anybody know this answer plz give the answer...
Is This Answer Correct ? | 2 Yes | 2 No |
AMD-00152: Workspace "string" is not currently open.
ORA-19508: failed to delete file "string"
SQL*Loader-00607: partition not empty for INSERT option; table string, partition string
ORA-27009: skgfwrt: cannot write to file opened for read
ORA-25296: Queue Table string has a buffered queue string
TNS-12612: TNS:connection is busy
PCB-00313: TO SAVEPOINT clause is an Oracle extension
ORA-07280: slsget: unable to get process information.
ORA-19758: failed to enable/disable block change tracking: out of SGA memory
ORA-12008: error in materialized view refresh path
RMAN-05501: aborting duplication of target database
ORA-00217: controlfile could not be resized for migration from 9.0.1