Home » Developer & Programmer » Forms » Ora-00600 cannot exeucte package of other schema (OS - XP windows)
Ora-00600 cannot exeucte package of other schema [message #480088] Thu, 21 October 2010 02:22 Go to next message
dornalpr
Messages: 8
Registered: October 2010
Junior Member
Hi,

I am using Oracle forms 6i, database 10g. Created a package containing 1 function in schema1.

Granted execute on this package to Schema2.
Created a public synonym on this package.

Now when im using this package in a form and compiling in schema2, it is giving Error 0 at Line 0, column 0.
Ora-00600: internal error code, arguments: [17069],[71101744],[],[],[],[]

If i compile in schema1, where package was originally created, it is compiling without any error. But i am not compile this in schema2.

Please let me know where i am going wrong.

Thanks in advance.

Praveen
Re: Ora-00600 cannot exeucte package of other schema [message #480098 is a reply to message #480088] Thu, 21 October 2010 03:41 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
ORA-00600 is usually a bad news, meaning - contact Oracle Support.

Though: did you try NOT to create a public synonym, but a private synonym instead? Or, reference package using SCHEMA.PACKAGE notation (in your case, that would be "schema1.package_name").
Re: Ora-00600 cannot exeucte package of other schema [message #480130 is a reply to message #480098] Thu, 21 October 2010 06:02 Go to previous messageGo to next message
dornalpr
Messages: 8
Registered: October 2010
Junior Member
If i give schema.package.function...it is compiling properly but i am not supposed to use schema name.

Earlier i was able to access tables of schema1 through schema2 without giving schema name before table name. But now after this package problem, i am not able to access tables also without schema name. Why is it so?

Reply would be appreciated.

Thanks
Praveen
Re: Ora-00600 cannot exeucte package of other schema [message #480131 is a reply to message #480130] Thu, 21 October 2010 06:04 Go to previous message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
You need to ask oracle support why that's happening.
Previous Topic: Record locking.
Next Topic: frm-40200 error in LOV
Goto Forum:
  


Current Time: Thu Sep 19 17:20:57 CDT 2024