Re: Please Help: ORA-00600 internal error

You might want to try Oracle's ODBC driver - the MS one may not be able to handle VARCHAR2(4000) fields ( in older versions of Oracle the limit was 2000, so the MS driver may be to old a version)
Also, try using the Oracle specific OLE-DB provider instead of the 'generic' ODBC one..

"Bilal EL JOUZOU" <bjouzou_at_fluxus.net> wrote:

>try to see the log file on your server $ORACLE_BASE\admin\$SID\bdump or
>$ORACLE_BASE\admin\$SID\bdump to see what is on the server
>
>"Diego Pasquale" <diegopasquale_at_allegroassai.com> a écrit dans le message
>news: 9j10ji$60f4$1_at_stargate1.inet.it...
>> Hi,
>>
>> I have some problem with an internal error and i can't figure out what i
>> should do... I'm using Oracle 8.1.6, i never experienced this type of
 error
>> before.
>>
>> I made a table (big table) with 30 fields of 4000 character and few other
>> minor fields. Now, when i try to insert a row (from an ODBC connection
>> through ASP pages) it seems the insert goes all well but when i try to
>> connect again to that table i got this message:
>>
>> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>>
>> [Oracle][ODBC][Ora]ORA-00600: internal error code, arguments: [smbwrt_1],
>> [], [], [], [], [], [], []
>>
>> Now, the strange thing is that if i cancel all the data from the 4000
>> characters fields everything seems to work and if i insert the same
 contents
>> in a new record AFTER the one I emptied all goes well again but if I
 delete
>> the incriminated record instead of empty it the error come back.
>>
>> Trying to insert again something the story starts from the beginning, with
>> the error and so on.
>>
>> Here is the table script:
>>
>> CREATE TABLE EMAIL
>>
>> EMAILID NUMBER,
>> TITLE VARCHAR2 (100),
>> DESCRIPTION VARCHAR2 (1000),
>> HTML1 VARCHAR2 (4000),
>> HTML2 VARCHAR2 (4000),
>> HTML3 VARCHAR2 (4000),
>> HTML4 VARCHAR2 (4000),
>> HTML5 VARCHAR2 (4000),
>> HTML6 VARCHAR2 (4000),
>> HTML7 VARCHAR2 (4000),
>> HTML8 VARCHAR2 (4000),
>> HTML9 VARCHAR2 (4000),
>> HTML10 VARCHAR2 (4000),
>> HTML11 VARCHAR2 (4000),
>> HTML12 VARCHAR2 (4000),
>> HTML13 VARCHAR2 (4000),
>> HTML14 VARCHAR2 (4000),
>> HTML15 VARCHAR2 (4000),
>> HTML16 VARCHAR2 (4000),
>> HTML17 VARCHAR2 (4000),
>> HTML18 VARCHAR2 (4000),
>> HTML19 VARCHAR2 (4000),
>> HTML20 VARCHAR2 (4000),
>> HTML21 VARCHAR2 (4000),
>> HTML22 VARCHAR2 (4000),
>> HTML23 VARCHAR2 (4000),
>> HTML24 VARCHAR2 (4000),
>> HTML25 VARCHAR2 (4000),
>> HTML26 VARCHAR2 (4000),
>> HTML27 VARCHAR2 (4000),
>> HTML28 VARCHAR2 (4000),
>> HTML29 VARCHAR2 (4000),
>> HTML30 VARCHAR2 (4000))
>> TABLESPACE RBS
>> PCTFREE 10 PCTUSED 40
>> INITRANS 1 MAXTRANS 255
>> STORAGE
>>
>> INITIAL 1048576 NEXT 1048576 PCTINCREASE 0
>> MINEXTENTS 2 MAXEXTENTS 121 )
>> NOCACHE;
>>
>>
>> What's the problem?
>> Thank you,
>> Diego.
>> P.S.: please, reply by mail too... diegopasquale_at_allegroassai.it
>>
>>
>>
>>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Tue Jul 17 2001 - 18:30:09 CEST