Home » Developer & Programmer » Forms » dbms_lock.sleep() (FORMS 6i and oracle database 11g-2.0.1.0)
dbms_lock.sleep() [message #657405] Tue, 08 November 2016 01:13 Go to next message
MohammedH
Messages: 7
Registered: November 2016
Junior Member
when I using dbms_lock.sleep(0.05)
it gives an error message says:
ora-00600: internal error code, arguments:[17069],[78434040],[],[],[],[],[],[]
Re: dbms_lock.sleep() [message #657406 is a reply to message #657405] Tue, 08 November 2016 01:28 Go to previous messageGo to next message
John Watson
Messages: 8135
Registered: January 2010
Location: Global Village
Senior Member
You need to provide more information. It works for me:
x122>
x122> exec dbms_lock.sleep(0.05)

PL/SQL procedure successfully completed.

x122> select * from v$version;

BANNER                                                                               CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.2.0.0.3 - 64bit Production              0
PL
Re: dbms_lock.sleep() [message #657407 is a reply to message #657405] Tue, 08 November 2016 01:40 Go to previous messageGo to next message
Michel Cadot
Messages: 66800
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Me too:
SQL> exec dbms_lock.sleep(0.05)

PL/SQL procedure successfully completed.

SQL> select * from v$version ;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production

ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink/MOS and/or call Oracle support
Have a look at alert.log and trace files.
You can also read this article: Troubleshooting Internal Errors.
And MOS notes:
ORA-600/ORA-7445/ORA-700 Error Look-up Tool (Doc ID 153788.1)
Master Note for Diagnosing ORA-600 (Doc ID 1092832.1)

Re: dbms_lock.sleep() [message #657408 is a reply to message #657406] Tue, 08 November 2016 01:53 Go to previous messageGo to next message
MohammedH
Messages: 7
Registered: November 2016
Junior Member
thanks John Watson
I'm using dbms_lock.sleep(0.05) within the forms 6i
Re: dbms_lock.sleep() [message #657409 is a reply to message #657408] Tue, 08 November 2016 01:54 Go to previous messageGo to next message
John Watson
Messages: 8135
Registered: January 2010
Location: Global Village
Senior Member
It has come to my attention that you appear to be in a country where use of Oracle products is not legal. This board is not hosted in the US and other members may choose to assist you, but I shall not.
Re: dbms_lock.sleep() [message #657410 is a reply to message #657407] Tue, 08 November 2016 01:54 Go to previous message
MohammedH
Messages: 7
Registered: November 2016
Junior Member
Thanks Michel for reply
but i'm using with forms 6i

[Updated on: Tue, 08 November 2016 02:01]

Report message to a moderator

Previous Topic: Not able to copy arabic text from excel to oracle forms 6i
Next Topic: Show Progress Bar During Report Initializing
Goto Forum:
  


Current Time: Sun Jan 26 11:48:09 CST 2020