according to metalink note id 209363.1, it seems that particular 600
should be treated as an ORA-24347. but agreed, that is so old.
dblink from version 7.3.4 instance to 9i "was" supported at one point.
i think the other way around, was never supported, see note id
207303.1.
TurkBear <john.greco_at_dot.state.mn.us> wrote in message news:<q1fl3v4u757312dk62o2av23h1ddogn6bd_at_4ax.com>...
> 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 - 17:17:17 CST
