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

LSX-00144: attribute "~1S" invalid derivation-restriction value "~2S"

1 Answers  


ORA-38703: Type string in header is not a flashback database log file.

1 Answers  


ORA-06801: TLI Driver: listen for SPX server reconnect failed

1 Answers  


PLS-00600: SAMPLE cannot be applied to a remote object

1 Answers  


ORA-09854: snyPortInfo: bad return code from request.

1 Answers  


ORA-31005: Path name length string exceeds maximum length string

1 Answers  


ORA-22339: cannot alter to not final since its attribute column is substitutable

1 Answers  


ORA-30373: object data types are not supported in this context

1 Answers  


NPL-00101: uninitialized ASN.1 context

1 Answers  


NZE-29226: No matching private key found.

1 Answers  


ORA-19676: one or more files failed during proxy backup or restore

1 Answers  


ORA-31158: schema "string" currently being referenced

1 Answers  


Categories