ORA-03114 after re login
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.