| userenv command [message #416372] |
Sat, 01 August 2009 04:01  |
GKANAND
Messages: 17
Registered: June 2009
|
Junior Member |
|
|
Hi
The below query is executing in sql*plus. But the same is giving
error in forms 6i.
Query:
SELECT UPPER(SYS_CONTEXT('USERENV','SESSIONID')) FROM DUAL;
Error:
identifier 'SYS_CONTEXT' must be declared.
What is the solution to run in forms 6i.
|
|
|
|
|
|
|
|
|
|
| Re: userenv command [message #416409 is a reply to message #416372] |
Sat, 01 August 2009 11:56  |
 |
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
|
If SYS_CONTEXT is not visible in your Forms version, perhaps you could create a database function (it would contain exactly the same SELECT statement you've successfully executed in SQL*Plus) and then call this function from a form.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
