Page 1 of 1

SYS_CONTEXT

Posted: Tue 16 May 2006 16:05
by IGLE
begin :Result := SYS_CONTEXT ('USERENV', 'CURRENT_SCHEMA');end;

Can anybody explain me why they call this every time. I don't change schema in session. I use schema name before tables. I use "net" conection. I don't need it. Can I remove this?

Posted: Wed 17 May 2006 08:04
by Challenger
In the latest versions of ODAC this code is called only when user requests value of Schema property. Please specify the version of ODAC you use.