Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and 126

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&gt; /
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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US