Re: Insert into a table problem...

Sashafay wrote:

> Hi,
>
> I have a little problem to create a table as insert into it. Select
> statement working fine but INSERT INTO blowing on a following line:
>
> COUNT(DECODE(SIGN(NVL((QTYIN*PRICE),0)), 0, NULL, SEQ))
>
> and produce an error
>
> ORA-00600: internal error code, arguments: [qerrmOFBu1], [24347], [],
> [], [], [], [], []
>
> Selecting and inserting used two Oracle version: Inserting INTO a
> table - Oracle9iR1, but selecting FROM - Oracle7.0.3 and using a link.
> There is anybody can help me to work around this issue?
>
> Thanks in advance,
> Alex

ORA-00600 is an unhandled internal error in Oracle that likely has nothing to do with your code (though from the little snipped you posted one could hardly guess what is really happening).

To solve this one you must contact Oracle and open a TAR.

Oops. Just noticed your reference to which I presume is 9.01 and 7.0.3. Want to clarify this? What hardware? What operating system? Do you have any reason to believe there is a compatibility between your code and 7.0.3? That is so old I can't remember when it was supported.

Daniel Morgan Received on Fri Jan 31 2003 - 01:19:18 CST