Alter Session Problems
Posted: Mon 25 Jul 2011 17:28
Hi,
I am trying to set the schema name by using:
ALTER SESSION SET CURRENT_SCHEMA = ""
When my application is run (btw - I have modified the OnContextCreated on my EF DataContext class)
This gets executed before any of my commands are executed when my context is created, but I am getting no results returned. If I manually run the commands for SQL Developer -
ALTER SESSION SET CURRENT_SCHEMA = Schema
SELECT * FROM TABLE
and I get results from the DB with no issues.
When I run these operations in my code I get no results. I have monitored the activity using dbMonitor and I see the following
-Connection Open
-Alter Statement Prepared/Executed
-Close Connection
-Open Connection
-Connection is taken from Pool
-Select Statement Prepared/Executed
-Close Connection
All under the same OracleConnection object.
Any ideas?
I am trying to set the schema name by using:
ALTER SESSION SET CURRENT_SCHEMA = ""
When my application is run (btw - I have modified the OnContextCreated on my EF DataContext class)
This gets executed before any of my commands are executed when my context is created, but I am getting no results returned. If I manually run the commands for SQL Developer -
ALTER SESSION SET CURRENT_SCHEMA = Schema
SELECT * FROM TABLE
and I get results from the DB with no issues.
When I run these operations in my code I get no results. I have monitored the activity using dbMonitor and I see the following
-Connection Open
-Alter Statement Prepared/Executed
-Close Connection
-Open Connection
-Connection is taken from Pool
-Select Statement Prepared/Executed
-Close Connection
All under the same OracleConnection object.
Any ideas?