Oracle Forms (MOSC)

MOSC Banner

ORA-03114 after re login

edited Jun 1, 2017 1:23AM in Oracle Forms (MOSC) 11 commentsAnswered ✓

Hi,

There is one strange issue is coming in forms. I tried in forms 6i (Forms [32 Bit] Version 6.0.8.11.3 (Production)), Forms 11g (Forms [32 Bit] Version 11.1.2.2.0 (Production)).

In the following code, I am getting error in the last line, while accessing the value from USER. The GET_APPLICATION_PROPERTY(USERNAME) works fine, but while using USER, gives me error ORA-03114.

MESSAGE('1 - ' || USER);PAUSE;LOGOUT;LOGON('<user_name>', '<password>');MESSAGE('2 - ' || GET_APPLICATION_PROPERTY(USERNAME));PAUSE;MESSAGE('3 - ' || USER);PAUSE;

Not only while using USER, but while accessing any tables from the new schema.

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