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!

ON-LOGON trigger

482169Sep 28 2007 — edited Sep 28 2007
I am trying use the ON-LOGON trigger to connect to the database
when a new form is called(from html page) by using the "logon(un,pw||'@'||db);" procedure:

I could use the 'userid=' parameter in thw URL to connect to the DB,
but I am trying to achieve this using ON-LOGON if possible.

I have declared a parameter in the form that will hold the connection string
value passed to the form through the URL. I can see this value if I call it from
WHEN-NEW-FORM-INSTANCE but I get the ORA-03114 if I use this value in the
ON-LOGON trigger to login.

Is there a way to pass the connection string to the form at runtime through the
calling URL?

Any suggestions?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2007
Added on Sep 28 2007
3 comments
923 views