Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get ora-06565 when set secure application role in form

351429Mar 17 2006 — edited Apr 20 2008
I wrote a package with invokers right to set up secure application role. The package runs successfully in sqlplus. I’d like to run this package for the Forms application

I tried to run this package in POST-LOGON trigger. The process failed with error ORA-06565 “cannot execute set_role from within stored procedure.”

Then I heard that dbms_session.set_role cannot be called in a logon trigger. Is there any alternate way to run the packge in Forms application? In sqlplus, the package can be executed directly (not inside logon trigger). How can I do it in Forms? Or what is the correct way to set up secure application role in Forms?

I just start to learn the Forms and use secure application role. Any helps are great appreciated.

Xiaoyun
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2008
Added on Mar 17 2006
4 comments
3,391 views