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

From: Onkar N Tiwary <onkarnath.tiwary_at_gmail.com>
Date: 2006-01-10 06:27:15
Message-id: a144e5210601092127g1983db20jfa02846336c311a@mail.gmail.com

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 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                   "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   v$process_at_dblink P,
            v$session_at_dblink S,
            v$lock_at_dblink l,
            sys.obj$@dblink lo,
            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.
       to_onkar_at_yahoo.com
       onkarnath.tiwary_at_gmail.com

Received on Tue Jan 10 2006 - 06:27:15 CST