OraFAQ Forum: Forms » dbms

Home » Developer & Programmer » Forms » dbms_lock.sleep() (FORMS 6i and oracle database 11g-2.0.1.0)

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

dbms_lock.sleep() [message #657405]

Tue, 08 November 2016 01:13

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],[],[],[],[],[],[]

Report message to a moderator

Re: dbms_lock.sleep() [message #657406 is a reply to message #657405]

Tue, 08 November 2016 01:28

John Watson
Messages: 8929
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

Report message to a moderator

Re: dbms_lock.sleep() [message #657407 is a reply to message #657405]

Tue, 08 November 2016 01:40

Michel Cadot
Messages: 68641
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)

Report message to a moderator

Re: dbms_lock.sleep() [message #657408 is a reply to message #657406]

Tue, 08 November 2016 01:53

MohammedH
Messages: 7
Registered: November 2016

Junior Member

thanks John Watson
I'm using dbms_lock.sleep(0.05) within the forms 6i

Report message to a moderator

Re: dbms_lock.sleep() [message #657409 is a reply to message #657408]

Tue, 08 November 2016 01:54

John Watson
Messages: 8929
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.

Report message to a moderator

Re: dbms_lock.sleep() [message #657410 is a reply to message #657407]

Tue, 08 November 2016 01:54

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 16:45:10 CDT 2024