Getting Invalid Cursor Error
Hi, I am having trouble with my code and it is generating an error in the alert logs and trace files. Can i ask for help?
Fri Sep 02 19:20:33 2011
Errors in file D:\oracle\dumps\prod_ora_5312.trc:
ORA-00600: internal error code, arguments: [17281], [1001], [0x680CAB34], [], [], [], [], []
ORA-01001: invalid cursor
The trace file says:
TraceFiles:
Oracle process number: 20
Windows thread id: 5312, image: ORACLE.EXE (SHAD)
*** SERVICE NAME:(PROD) 2011-09-02 10:43:22.592
*** SESSION ID:(133.14370) 2011-09-02 10:43:22.592
*** 2011-09-02 10:43:22.592
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17281], [1001], [0x680CAB34], [], [], [], [], []
ORA-01001: invalid cursor
Current SQL statement for this session:
declare cursor NlsParamsCursor is SELECT FROM nls_session_parameters;begin SELECT Nvl(Lengthb(Chr(65536)), Nvl(Lengthb(Chr(256)), 1)) INTO :CharLength FROM dual; for NlsRecord in NlsParamsCursor loop if NlsRecord.parameter = 'NLS_DATE_LANGUAGE' then :NlsDateLanguage := NlsRecord.value; elsif NlsRecord.parameter = 'NLS_DATE_FORMAT' then :NlsDateFormat := NlsRecord.value; elsif NlsRecord.parameter = 'NLS_NUMERIC_CHARACTERS' then :NlsNumericCharacters := NlsRecord.value; elsif NlsRecord.parameter = 'NLS_TIMESTAMP_FORMAT' then :NlsTimeStampFormat := NlsRecord.value; elsif NlsRecord.parameter = 'NLS_TIMESTAMP_TZ_FORMAT' then :NlsTimeStampTZFormat := NlsRecord.value; end if; end loop;end;*
What is wrong with this code and how can i resolve this? Thanks!
Edited by: gab-gab on Sep 2, 2011 7:36 PM