Re: Insert into a table problem...

If your 'Insert into' sql is running on the 7.3 client side and uses a Database link to the 9i server, it may be incompatible.
 Whenever attempting a very old to quite new ( altho' in Oracle land 9.0 is also old) connection there can be many problems introduced..Follow Daniel's advice and contact Oracle... In the interim,
You could try creating a database link on the 9.0 side and use that version Of SqlPlus to work with the 7.3 as the remote table..

afayfman_at_mwh.com (Sashafay) wrote:

>DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E3A2376.B6821A6D_at_exesolutions.com>...
>> 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
>
>Daniel,
>
>I have to apologies for my typo about Oracle 7.0.3 that I clarify
>below by answering on your questions...
>-------------------------------------------------
>Oracle7 Server Release 7.3.4.5.0 - Production
>PL/SQL Release 2.3.4.5.0 - Production
>CORE Version 3.5.4.0.0 - Production
>TNS for Solaris: Version 2.3.4.0.0 - Production
>NLSRTL Version 3.2.4.0.0 - Production
>-------------------------------------------------
>Oracle9i Enterprise Edition Release 9.0.1.3.0 - Production
>PL/SQL Release 9.0.1.3.0 - Production
>CORE 9.0.1.2.0 Production
>TNS for Solaris: Version 9.0.1.3.0 - Production
>NLSRTL Version 9.0.1.3.0 - Production
>--------------------------------------------------
>SunOS tantalus 5.6 Generic_105181-32 sun4u sparc SUNW,Ultra-Enterprise
>
>Those three operation system involved in my problem
>
>Hopes this will help!
>
>Alex
Received on Fri Jan 31 2003 - 12:17:17 CST