Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

GET_APPLICATION_PROPERTY(DATASOURCE) = 'ORACLE' DS 10gR1 vs. DS 10gR2

485377Sep 8 2006 — edited Jan 10 2008
I have a form that was compiled under 10gR1 DS and launches fine, but after compiling it under 10gR2 DS it is not responding in the same manner as 10gR1 to an if statement in the code checking to see if it is connected to an ORACLE database.

In the 10gR1 version of the form
The check to see if the form was connected to an oracle database would return false after EXIT_FORM(NO_VALIDATE);
And this is what was expected to happen with the 10gR2 version of the form.

But in the 10gR2 version of the form
After the EXIT_FORM(NO_VALIDATE); statement
the if GET_APPLICATION_PROPERTY(DATASOURCE) = 'ORACLE' statment returns a true and causes the form to break because its not connected to the database anymore but the code in this if statement contains sql against database tables

How come only for DS 10gR2 after the EXIT_FORM(NO_VALIDATE); statement
the get_application_property(DATASOURCE) = 'ORACLE' is true, Even though its not connected to the database anymore?

Thanks,
Michelle

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 7 2008
Added on Sep 8 2006
#forms, #moved-from-devops
3 comments
604 views