how to resolve the sqlcode -501 erroe in db2?
Answers were Sorted based on User's Feedback
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 |
Answer / avinash
if anybody know this answer plz give the answer...
| Is This Answer Correct ? | 2 Yes | 2 No |
ORA-28501: communication error on heterogeneous database link
ORA-25109: standby lock name space has illegal character 'string'
TNS-04065: The number of remote CMCTL sessions exceeds (MAX_CMCTL_SESSIONS-1)
RMAN-06742: platform name 'string' longer than number
ORA-13194: failed to decode supercell
ORA-00227: corrupt block detected in controlfile: (block string, # blocks string)
ORA-14048: a partition maintenance operation may not be combined with other operations
ORA-31076: required attribute "string" not specified
TNS-01180: Missing listener object string in Directory Server
ORA-29527: created Java source string"string"
IMP-00053: Import mode incompatible with Export dump file
ORA-02284: duplicate INCREMENT BY specifications