Re: ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and 126

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: 2006-01-10 08:10:29
Message-id: 6.2.1.2.0.20060110150809.01faae60@pop.singnet.com.sg

Solution : Set
event="10499 trace name context forever, level 4" Bug Text :
Number Datatype
returns -127 instead of 0 for unspecified scale [when using Oracle Clients below 9.2.0.3]
Reference : Bugs
2235818,
2755842.
Metalink Note :
Note
255902.1
At 01:27 PM Tuesday, Onkar N Tiwary wrote: Hi,

I have one query , when I am running this query against the remote database, its working fine but when I am putting this in pl/sql block its giving the following error:

****************************************************************************************** \

SQL> /
insert into oneapps_db_lock_info
*
ERROR at line 2:
ORA-06550: line 2, column 1:
PL/SQL: ORA-04052: error occurred when looking up remote object mailto:SYS.OBJ$@TMOLDB_COCHIN.ONEAPPS.COM 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 ORA-06550: line 2, column 1:
PL/SQL: SQL Statement ignored

****************************************************************************************** \ 
***************************

the query is :

begin
insert into oneapps_db_lock_info

SELECT substr(to_char(l.sid),1,4) "SID",

           
substr(s.type,1,1)         
"BU",
           
P.spid               \ 
       
"SRVR_PID", 
           
s.process             &nb \

sp;
"CLNT_PID",

           
substr(s.machine,1,7)      
"MACHINE",
           
l.type,
           
DECODE(L.TYPE,'MR','File_ID: '||L.ID1,
                \ 
          


'TM', LO.NAME,

                \

'TX','USN: '||to_char(TRUNC(L.ID1/65536))||' RWO:

'||nvl(RWO.NAME,'None'),L.ID1)
LOCK_ID1, decode(l.lmode ,

0,
'None',

1,
'Null',

2,
'Row-S (SS)',

3,
'Row-X (SX)',

4,
'Share',

5,
'S/Row-X (SSX)',

6,
'Exclusive',

substr(to_char( l.lmode),1,13)) Locked_Mode,

decode(l.request,

0,
'None',

1,
'Null',

2,
'Row-S (SS)',

3,
'Row-X (SX)',

4,
'Share',

5,
'S/Row-X (SSX)',

6,
'Exclusive',

substr(to_char(l.request),1,13)) Requested,

l.ctime,

l.block,'Geojit Financial Services'
Client_name,'TMOLDB.NET ' Database_name,sysdate DOP

FROM
mailto:v$process_at_dblink P,

mailto:v$session_at_dblink S,

mailto:v$lock_at_dblinkl,

mailto:sys.obj$@dblink lo,

mailto:sys.obj$@dblink rwo

WHERE l.type
!= 'MR'

     AND   
l.sid       = S.sid   (+)
     AND   
S.paddr     = P.addr (+)
     AND    LO.OBJ#(+)  =
L.ID1
     AND    RWO.OBJ#(+) =
S.ROW_WAIT_OBJ#
     order by l.sid;

end;
/

As I said , if I am omitting BEGIN..END ,its working but once I am adding this its producing error. Any idea?????????????

-- 
Thanks &amp; Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
      
mailto:to_onkar_at_yahoo.com
      
mailto:onkarnath.tiwary_at_gmail.com
 


Hemant K Chitale
<a href="http://web.singnet.com.sg/~hkchital" eudora="autourl">
http://web.singnet.com.sg/~hkchital
</a>


--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 10 2006 - 08:10:29 CST