how to resolve the sqlcode -501 erroe in db2?

Question Posted / avinash

2 Answers
18995 Views
Syntel, I also Faced
E-Mail Answers

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-00362: member is required to form a valid logfile in group string

1 Answers

RMAN-06204: Changed string objects to UNAVAILABLE status

1 Answers

ORA-12044: invalid CREATE MATERIALIZED VIEW LOG option

1 Answers

ORA-24083: cannot specify remote subscribers for string QUEUE string

1 Answers

RMAN-06194: target database instance not started

1 Answers

PCC-00038: Unable to open a cursor

1 Answers

RMAN-06605: old RMAN configuration parameters are successfully deleted

1 Answers

ORA-01338: Other process is attached to LogMiner session

1 Answers

ORA-22606: pickler image handle [string] is not well-formed

1 Answers

ORA-28113: policy predicate has error

1 Answers

ORA-12984: cannot drop partitioning column

1 Answers

RMAN-06148: redundancy count must be greater than zero

1 Answers

For more Oracle Errors Interview Questions Click Here