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

NNL-00803: Queries received, type ALIAS: number

1 Answers  


ORA-30039: Cannot drop the undo tablespace

1 Answers  


TNS-12672: Database logon failure

1 Answers  


ORA-13461: the interleaving type is not supported

1 Answers  


SQL*Loader-00107: Invalid maximum number of discards

1 Answers  






KUP-02005: token too big

1 Answers  


EXP-00087: Problem with internal hash table of schema/table names

1 Answers  


ORA-38401: synonym string not allowed

1 Answers  


RMAN-03040: Spooling for trace turned off

1 Answers  


ORA-39109: Unprivileged users may not operate upon other users' schemas

1 Answers  


ORA-39705: component 'string' not found in registry

1 Answers  


ORA-25276: table specified is not a queue table

1 Answers  


Categories