X-list: oracle-l Return-Path: Subject: Re: ORA-06553: PLS-623: FLOAT precision constraint must be between 1 and 126 From: Hemant K Chitale Message-id: 6.2.1.2.0.20060110150809.01faae60@pop.singnet.com.sg Date: 2006-01-10 08:10:29 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@dblink P, mailto:v$session@dblink S, mailto:v$lock@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 & Regards, T. Onkar Nath OneAPPS Enterprise Technology Pvt. Ltd. mailto:to_onkar@yahoo.com mailto:onkarnath.tiwary@gmail.com Hemant K Chitale http://web.singnet.com.sg/~hkchital -- http://www.freelists.org/webpage/oracle-l