Re: ORA-4052 querying in PLSQL across a DB-Link from 9.2.0.1 to
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 asked me to rerun catalog.sql and catproc.sql but
I referred back to the Note and Bugs when I closed the TAR.
Thanks again !
Hemant
At 01:39 PM 22-09-03 -0800, you wrote:
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 Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 22, 2003 6:34 PM
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 get 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
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).
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
ORA-4052 querying in PLSQL across a DB-Link from 9.2.0.1 to
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 get 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).
Re: ORA-4052 querying in PLSQL across a DB-Link from 9.2.0.1 to
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 9.2.0.2 to 9.2.0.4] databasethrough 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-Tru64databases 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 l1 select count(*)2 from [EMAIL PROTECTED] dtbs,3 [EMAIL PROTECTED] ddfs4 where dtbs.tablespace_name = ddfs.tablespace_name5* and ddfs.status = 'AVAILABLE'SQL /COUNT(*)--7SQLPLSQL :SQL g!
et
X1.sql1 declare2 cnt number;3 begin4 select count(*) into cnt5 from [EMAIL PROTECTED] dtbs,6 [EMAIL PROTECTED] ddfs7 where dtbs.tablespace_name = ddfs.tablespace_name8 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 126ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and 126ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and 126ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and 126ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and 126ORA-06553: PLS-623: FLOAT precision constraint must be betORA-06550: line 4, column 1:PL/SQL: SQL Statement
ignoredSQLI've logged a Priority-2 TAR with Support currently but wonder if someoneelse 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 ChitaleOracle 9i Database Administrator Certified ProfessionalMy personal web site is : http://hkchital.tripod.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Hemant K ChitaleINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you!
want to
be removed from). You mayalso send the HELP command for other information (like subscribing).
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
Re: ORA-4052 querying in PLSQL across a DB-Link from 9.2.0.1 to
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 Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 22, 2003 6:34 PM
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 get 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
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).
