Skip to Main Content

APEX

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!

How to get a global application item value from another application?

AllenS.May 30 2019 — edited Jun 6 2019

Hi,

I have application A where I defined several application items as global. This application also had the login page for all my applications meaning every other applications redirects to this applications login page for authentication. The home page for application A has a branch on page load that redirects to the appropriate application and page for ex: application B page 1.

On my login function, I set session state values for the application A application items. However, trying to get the value from application B doesn't seem to work as it returns a null value unless I define that same application item in application B.

Is there anyway do get the value without defining the item in other applications?

UPDATE:

Even though the item returns null when referencing it through &MY_ITEM. or v('MY_ITEM'), when I click the Session button on the bottom

pastedImage_0.png

and list all Items, the MY_ITEM is shown with a value in the list.

How does this Session window get the value?

Regards,

Allen

This post has been answered by Scott Wesley on May 30 2019
Jump to Answer

Comments

Gbenga Ajakaye

Check this other thread with similar error and some suggested solution from @Jeff Smith Sqldev Pm-Oracle.

Sql Developer 4.1.2 on Windows 7 64 bit doesn't start

Kvark

Already, do not help, that is why i create that topic, as see in many places people start asking that question... so I am not alone who have this issue.

thatJeffSmith-Oracle

the jars got corrupted or missing. delete everything, unzip the files again, and what archive software are you using to get the files out of the ZIP?

Kvark
Answer

Manage to run it! I can't explain that, but once I move sqldeveloper folder to the root of C:\ drive - its finally start fine!

Seems its a bug in it to find a required libraries if its saved somewhere else and not in C:\ drive

Marked as Answer by Kvark · Sep 27 2020
1 - 4

Post Details

Added on May 30 2019
9 comments
2,131 views