ORA-00600 with Bind variable. Please help!

From: Liu, Jack <jliu_at_atla.com>
Date: Wed, 06 Aug 2003 15:59:23 -0800
Message-ID: <F001.005C94C7.20030806155923@fatcity.com>

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: jliu_at_atla.com

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: ListGuru_at_fatcity.com (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).

Received on Wed Aug 06 2003 - 18:59:23 CDT