Oracle Forms (MOSC)

MOSC Banner

How do I retrieve data from a view created and saved in Oracle Forms 6i w/ dB 10g?

in Oracle Forms (MOSC) 3 commentsAnswered ✓

I have a form(6i) running against Oracle dB 10g w/ the following code in the "WHEN-BUTTON-PRESSED" Trigger:

BEGIN

GO_ITEM('SCOPE.TEXT_DATE');

SHOW_VIEW('SCOPE');

END;

It looks like the object is a View called 'SCOPE' and is being populated in the form, but how do I retrieve the data from the view 'SCOPE' since it does not physically exist in my schema?

Thank you very much in advance for any/all the help, Jinlan 🙏

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center