Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_SESSION.SET_ROLE error (merged 3)
DBMS_SESSION.SET_ROLE error (merged 3) [message #399999] Fri, 24 April 2009 22:30 Go to next message
shahidmahmood2069
Messages: 11
Registered: February 2009
Junior Member
I have written role and assigned that role to user but not as default role then In my form in when_new_form_instance I write
DBMS_SESSION.SET_ROLE('R_WRITE');
but when I complied my file I got this error
ora-00600 internal error code arguments [17069], [51512860], [], [],..
I am using 10g with form 6.
Is there any hint what error is this and how to remove it.
thanks
Re: DBMS_SESSION.SET_ROLE error [message #400001 is a reply to message #399999] Fri, 24 April 2009 22:55 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>I am using 10g with form 6.
Not a supported configuration

>ora-00600 internal error code arguments [17069], [51512860]
Submit a Service Request

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.

DBMS_SESSION.SET_ROLE error [message #400006 is a reply to message #399999] Fri, 24 April 2009 23:57 Go to previous messageGo to next message
shahidmahmood2069
Messages: 11
Registered: February 2009
Junior Member
I have written role and assigned that role to user but not as default role then In my form in when_new_form_instance I write
DBMS_SESSION.SET_ROLE('R_WRITE');
but when I complied my file I got this error
ora-00600 internal error code arguments 17069, 51512860], [, [],..
I am using 10g with form 6.
Is there any hint what error is this and how to remove it.
Re: DBMS_SESSION.SET_ROLE error [message #400007 is a reply to message #400006] Fri, 24 April 2009 23:59 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/m/400001/136107/#msg_400001

Do NOT cross/multi-post!

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.

DBMS_SESSION.SET_ROLE error [message #400010 is a reply to message #399999] Sat, 25 April 2009 00:29 Go to previous messageGo to next message
shahidmahmood2069
Messages: 11
Registered: February 2009
Junior Member
I have written role and assigned that role to user but not as default role then In my form in when_new_form_instance I write
DBMS_SESSION.SET_ROLE('R_WRITE');
but when I complied my file I got this error
ora-00600 internal error code arguments 17069, 51512860], [, [],..
I am using 10g with form 6.
Is there any hint what error is this and how to remove it.
Re: DBMS_SESSION.SET_ROLE error [message #400012 is a reply to message #400010] Sat, 25 April 2009 00:36 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
What is your problem?

Are you GUI impaired?

Do NOT cross/multi-post!

http://www.orafaq.com/forum/t/144184/136107/

[Updated on: Sat, 25 April 2009 00:37]

Report message to a moderator

Re: DBMS_SESSION.SET_ROLE error (merged 3) [message #400018 is a reply to message #399999] Sat, 25 April 2009 00:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel
Re: DBMS_SESSION.SET_ROLE error (merged 3) [message #400024 is a reply to message #399999] Sat, 25 April 2009 01:23 Go to previous message
mamalik
Messages: 266
Registered: November 2008
Location: Pakistan
Senior Member

Dear

Install Patch 17 and try. I think it can be solved by installing patch.

Regards.
Asif.
Previous Topic: Pls help to write SQL
Next Topic: Pls help me to write an interesting SQL query
Goto Forum:
  


Current Time: Sun Dec 11 08:29:03 CST 2016

Total time taken to generate the page: 0.15202 seconds