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 |
ORA-00232: snapshot controlfile is nonexistent, corrupt, or unreadable
TNS-02404: Service string contains no local handlers
ORA-07246: sfofi: open error, unable to open database file.
CLSR-06501: Exceeds maximum number of arguments
ORA-31676: illegal value for number of workers, string
LSX-00231: invalid unsigned integer "~S"
NNL-00009: encryption of server password failed
NNC-00416: user callback function returned error number string
ORA-34871: (PERMIT06) Session-only value 'value' of workspace object has been deleted because a PERMIT change has revealed a duplicate value.
ORA-12153: TNS:not connected
ORA-16731: Error executing dbms_logstdby.unskip_txn procedure
ORA-27145: insufficient resources for requested number of processes