Hi, I got this error when I run my procedure: <!-- SQL ERROR:ORA-00600: internal error code, arguments: [15212], [1], [], [], [], [], [], [] --> Errors in file /ora817/app/oracle/admin/ORCL/udump/orcl_ora_4345.trc
ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [15212], [1], [], [], [], [], [], [] Here is part of my procedure: query:='select/*+ FIRST_ROWS */ from article a where a.aid=e.aid and d.eventid=e.eventid and d.verbid=''REVW'''||chr(13)||' and d.actorid=:mactor '||chr(13); handle:=dbms_sql.open_cursor; dbms_sql.parse(handle,query,dbms_sql.native); dbms_sql.bind_variable(handle, ':mactor', myactorid); dbms_sql.define_column_char(handle,11,nresult,24); rownum:=dbms_sql.execute(handle); dbms_sql.column_value_char(handle,11,myrnum); dbms_sql.close_cursor( handle ); Thanks, Jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Liu, Jack INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).