Did you check if it is a privilege issue because the access privilege is granted thru a role. roles are not recognised in PL/SQL
Hemant K Chitale <[EMAIL PROTECTED]> wrote:
Hemant K Chitale <[EMAIL PROTECTED]> wrote:
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 DBSNMP account, with some additonal custom views}
Here @HRDM is a DB-Link to the 9.2.0.4/Solaris Database :
When querying across a DB-Link I get no errors if the query is an SQL query.
However, I get ORA-4052 and other errors when I put the query in a PLSQL
block.
SQL :
SQL> l
1 select count(*)
2 from [EMAIL PROTECTED] dtbs,
3 [EMAIL PROTECTED] ddfs
4 where dtbs.tablespace_name = ddfs.tablespace_name
5* and ddfs.status = 'AVAILABLE'
SQL> /
COUNT(*)
----------
7
SQL>
PLSQL :
SQL> g! et X1.sql
1 declare
2 cnt number;
3 begin
4 select count(*) into cnt
5 from [EMAIL PROTECTED] dtbs,
6 [EMAIL PROTECTED] ddfs
7 where dtbs.tablespace_name = ddfs.tablespace_name
8 and ddfs.status = 'AVAILABLE';
9 dbms_output.put_line('Cnt is '||cnt);
10* end;
SQL> /
select count(*) into cnt
*
ERROR at line 4:
ORA-06550: line 4, column 1:
PL/SQL: ORA-04052: error occurred when looking up remote object
[EMAIL PROTECTED]
ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and 126
ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and 126
ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and 126
ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and 126
ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and 126
ORA-06553: PLS-623: FLOAT precision constraint must be bet
ORA-06550: line 4, column 1:
PL/SQL: SQL Statement ignored
SQL>
I've logged a Priority-2 TAR with Support currently but wonder if someone
else can reproduce this {I can reproduce it on the only 2 9.2.0.4 instances
I have,
both Solaris, connecting from the 9.2.0.1 instance}
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : http://hkchital.tripod.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you! want to be removed from). You may
also send the HELP command for other information (like subscribing).
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
