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
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@dblink P,
v$session@dblink S,
v$lock@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@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx
Hemant K Chitale
http://web.singnet.com.sg/~hkchital
--
//www.freelists.org/webpage/oracle-l