Oracle Forms (MOSC)

MOSC Banner

Cursor in menu item code not returning correct database value

edited Jan 30, 2012 3:16AM in Oracle Forms (MOSC) 4 commentsAnswered
Hi

We have a table called system_parameters

The value of one of the system_parameter records can be either C or O.

Code behind a menu item checks the value of the system_parameter record before deciding on which processing path to take.

We came across a situation recently where the menu item code took the processing path when the value of the system parameter being C even though the actual value of the system parameter was O

In short

The value of the system_parameter record is O

When we check the value of the system parameter using SQL+ O is returned.

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