Tags: application, current_schema, database, environment, functionsys_context, manual, mysql, oracle, rac, reference, sql, sys_context, userenv
SYS_CONTEXT and RAC environment
In my application I need to use function:
but I found in SQL Reference manual this Note
"Note: SYS_CONTEXT returns session attributes. Therefore, you
cannot use it in parallel queries or in a Real Application Clusters
Since my application is installed in many different environment (9i, 10gR2, with or
without RAC, etc.) I would know the limitation in using SYS_CONTEXT ('USERENV','CURRENT_SCHEMA') and
what can I use instead of.
Leave a comment...
- 2 Comments
Well, you can use SYS_CONTEXT ('USERENV','CURRENT_SCHEMA') with RAC. BUT, if your application is using ALTER SESSION SET CURRENT_SCHEMA then this setting will not be carried over to another RAC node in the event of a failover. The application would need to detect this and reissue the ALTER SESSION SET CURRENT_SCHEMA.
Rod West#1; Sat, 23 Feb 2008 23:40:00 GMT
- By now for me it's enough if I get no error. Thank you a lot.#2; Sat, 23 Feb 2008 23:41:00 GMT