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 |
NNL-00353: Not allowed
ORA-01626: rollback segment number 'string' cannot handle more transactions
LSX-00164: no content specified in "~S"
LSX-00153: invalid combination of default and fixed attributes
ORA-10586: Test recovery had to corrupt 1 data block in order to proceed
ORA-31215: DBMS_LDAP: PL/SQL - Invalid LDAP mod value.
ORA-01718: BY ACCESS | SESSION clause not allowed for NOAUDIT
NID-00309: Control File string - wrote new name
ORA-12418: user string not found
RMAN-06192: maximum value for MAXPIECESIZE or MAXSETSIZE must be between 1 Kb and 2048 Gb
ORA-13626: The specified object string is not valid for task string.
ORA-00312: online log string thread string: 'string'