OraFAQ Forum: Forms » ORA-00600 Internal Error [] [] []

Home » Developer & Programmer » Forms » ORA-00600 Internal Error [] [] [] (Oracle forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00600 Internal Error [] [] [] [message #609756]

Tue, 11 March 2014 22:33

shan_
Messages: 3
Registered: February 2014
Location: Singapore

Junior Member

Hi ,

I can compile my .fmb in my system. but when I try to compile it other system its throwing the error as

ORA-00600 Internal Error [] [] [].

I goggled for this error.

Is it necessary to contact Oracle support?

if yes please assist me if anybody resolve this.

Thanks & Regards,
Sujitha.M

Report message to a moderator

Re: ORA-00600 Internal Error [] [] [] [message #609760 is a reply to message #609756]

Wed, 12 March 2014 01:09

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Is it necessary? Can't tell (by the way, why wouldn't you contact Oracle? They don't bite, you know).

All we know is that you use Forms 6i and error code you got. Could you provide some more information? What operating systems are involved (as you said that you did that on different systems)? Which databases?

Report message to a moderator

Re: ORA-00600 Internal Error [] [] [] [message #609842 is a reply to message #609756]

Thu, 13 March 2014 01:33

mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan

Member

Dear all

I also have a same issue
when i use
i have a code at when_validate_item
my item code will be validate if its length =15
other wise it is wrong code

my code is

declare
len number;
begin
select length(:acc_detail.ac_code) into len from dual;
if len<>15 then
message('code is not valid..');
end if;
end;

when i compile this code then give me error as same
i am using form6i and 11g database what will be the issue.

Report message to a moderator

Re: ORA-00600 Internal Error [] [] [] [message #609844 is a reply to message #609842]

Thu, 13 March 2014 01:48

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Try to rewrite code; you don't need to SELECT FROM DUAL, this is enough:

len := length(:acc_detail.ac_code);

Moreover, even better is to use

if length(:acc_detail.ac_code) <> 15 then
   message('code is not valid');
end if;

i.e. you don't need anything else in that trigger.

If that doesn't work, create a stored function (in the database) which would accept :acc_detail.ac_code value and return Boolean, such as

-- database function
create or replace function f_len (par_ac_code in varchar2) return boolean is
begin
  return length(par_ac_code) <> 15;
end;

WHEN-VALIDATE-ITEM would then be

if f_len(:acc_detail.ac_code) then
   message('code is not valid');
end if;

Report message to a moderator

Re: ORA-00600 Internal Error [] [] [] [message #609845 is a reply to message #609844]

Thu, 13 March 2014 02:18

mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan

Member

thanks dear.

Report message to a moderator

Previous Topic:	Form 11g 32-Bit Development to 64-Bit deployment
Next Topic:	Dynamic where clause for static cursor

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 17:22:38 CDT 2024