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

AMD-00152: Workspace "string" is not currently open.

1 Answers  


ORA-19508: failed to delete file "string"

1 Answers  


SQL*Loader-00607: partition not empty for INSERT option; table string, partition string

1 Answers  


ORA-27009: skgfwrt: cannot write to file opened for read

1 Answers  


ORA-25296: Queue Table string has a buffered queue string

1 Answers  






TNS-12612: TNS:connection is busy

1 Answers  


PCB-00313: TO SAVEPOINT clause is an Oracle extension

1 Answers  


ORA-07280: slsget: unable to get process information.

1 Answers  


ORA-19758: failed to enable/disable block change tracking: out of SGA memory

1 Answers  


ORA-12008: error in materialized view refresh path

1 Answers  


RMAN-05501: aborting duplication of target database

1 Answers  


ORA-00217: controlfile could not be resized for migration from 9.0.1

1 Answers  


Categories