| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Insert into a table problem...
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...
Those three operation system involved in my problem
Hopes this will help!
Alex Received on Fri Jan 31 2003 - 11:50:09 CST
 |
 |