Re: ORA-4052 querying in PLSQL across a DB-Link from 9.2.0.1 to

2003-09-24 Thread Hemant K Chitale
Tanel, Thanks ! Yes, your suggestion was the right fix. {I can't upgrade ALL the clients and remote databases to 9.2.0.3} I set event 10499. I referred to Note 241355.1 and Bugs 2235818 and 2960493 and set 10499 at level 4 [although any non-zero value should suffice] The Support Analyst had

ORA-4052 querying in PLSQL across a DB-Link from 9.2.0.1 to

2003-09-22 Thread Hemant K Chitale
I face this peculiar behaviour when I connect from my 9.2.0.1/Tru64 database to a 9.2.0.4/Solaris [upgraded from 9.2.0.1 to 9.2.0.2 to 9.2.0.4] database through a Database Link. {I use the 9.2.0.1/Tru64 Database to monitor a number of other 8.0--9.2.0.2/NT-Solaris-Tru64 databases using the

Re: ORA-4052 querying in PLSQL across a DB-Link from 9.2.0.1 to

2003-09-22 Thread raju pa
Did you check if it is a privilege issue because the access privilege is granted thru a role. roles are not recognised in PL/SQLHemant K Chitale [EMAIL PROTECTED] wrote: I face this peculiar behaviour when I connect from my 9.2.0.1/Tru64 databaseto a 9.2.0.4/Solaris [upgraded from 9.2.0.1 to

Re: ORA-4052 querying in PLSQL across a DB-Link from 9.2.0.1 to

2003-09-22 Thread Tanel Poder
Hi! Try to set event 10499 at level 1 in your remote server. Or upgrade the client to at least 9.2.0.3. You get more information from metalink when searching for this event in metalink, it's about float scale representation change in 10i (which was backported to 9.2.0.3). Tanel. - Original