how to resolve the sqlcode -501 erroe in db2?

Answers were Sorted based on User's Feedback



how to resolve the sqlcode -501 erroe in db2?..

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

how to resolve the sqlcode -501 erroe in db2?..

Answer / avinash

if anybody know this answer plz give the answer...

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00232: snapshot controlfile is nonexistent, corrupt, or unreadable

1 Answers  


TNS-02404: Service string contains no local handlers

1 Answers  


ORA-07246: sfofi: open error, unable to open database file.

1 Answers  


CLSR-06501: Exceeds maximum number of arguments

1 Answers  


ORA-31676: illegal value for number of workers, string

1 Answers  


LSX-00231: invalid unsigned integer "~S"

1 Answers  


NNL-00009: encryption of server password failed

1 Answers  


NNC-00416: user callback function returned error number string

1 Answers  


ORA-34871: (PERMIT06) Session-only value 'value' of workspace object has been deleted because a PERMIT change has revealed a duplicate value.

1 Answers  


ORA-12153: TNS:not connected

1 Answers  


ORA-16731: Error executing dbms_logstdby.unskip_txn procedure

1 Answers  


ORA-27145: insufficient resources for requested number of processes

1 Answers  


Categories