Home » SQL & PL/SQL » SQL & PL/SQL » I am facing Error, (windowsNT2000,oracle 9.0.1.1.1)
I am facing Error, [message #284575] Fri, 30 November 2007 02:45 Go to next message
sujeetsaxena16
Messages: 9
Registered: May 2007
Location: mumbai
Junior Member

dear sir,

I am facing problem while select the record from remote database and insert into source database.

Its working fine when its working only as query but its give the error when we put this query in the procedure.

Error.LINE/COL ERROR
-------- -----------------------------------------------------------------
6/1 PL/SQL: ORA-04052: error occurred when looking up remote object
SYS.V_$INSTANCE@TEST_LINK_NRI.RECONDOMAIN.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

6/1 PL/SQL: SQL Statement ignored
Re: I am facing Error, [message #284581 is a reply to message #284575] Fri, 30 November 2007 03:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Useless title
2/ No Oracle versions (both side)
3/ No formating
4/ No code
5/ No object definition
...


Read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Always post your Oracle version (4 decimals).

Regards
Michel
Re: I am facing Error, [message #284594 is a reply to message #284581] Fri, 30 November 2007 04:27 Go to previous messageGo to next message
sujeetsaxena16
Messages: 9
Registered: May 2007
Location: mumbai
Junior Member

sorry for my mistake

Oracle Version:9.0.1.1.1
Os:Windows NT2000

I am facing problem while select the record from remote database and insert into source database.

Its working fine when its working only as query but its give the error when we put this query in the procedure.

Error.LINE/COL ERROR
-------- -----------------------------------------------------------------
6/1 PL/SQL: ORA-04052: error occurred when looking up remote object
SYS.V_$INSTANCE@TEST_LINK_NRI.RECONDOMAIN.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

6/1 PL/SQL: SQL Statement ignored

thanks
Sujit
Re: I am facing Error, [message #284597 is a reply to message #284594] Fri, 30 November 2007 04:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Still no code, still not formated, still no table description.

Regards
Michel
Re: I am facing Error, [message #284735 is a reply to message #284594] Fri, 30 November 2007 14:06 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
sujeetsaxena16 wrote on Fri, 30 November 2007 05:27



Error.LINE/COL ERROR
-------- -----------------------------------------------------------------
6/1 PL/SQL: ORA-04052: error occurred when looking up remote object
SYS.V_$INSTANCE@TEST_LINK_NRI.RECONDOMAIN.COM



That's easy. Fix line 6.
Re: I am facing Error, [message #284737 is a reply to message #284575] Fri, 30 November 2007 14:15 Go to previous messageGo to next message
BlackSwan
Messages: 25038
Registered: January 2009
Location: SoCal
Senior Member
GOOGLE is your friend but ONLY when you actually use it.

Refer to Note 241355.1 and Bugs 2235818 and 2960493
and set 10499 at level 4 [although any non-zero value should suffice]
Re: I am facing Error, [message #285473 is a reply to message #284575] Tue, 04 December 2007 15:41 Go to previous message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
Also it is kind of hard to figure out a query when you refuse to show us what the query is.
Previous Topic: Date Minus Time Query
Next Topic: Simple query involving count
Goto Forum:
  


Current Time: Mon Dec 05 15:06:36 CST 2016

Total time taken to generate the page: 0.09498 seconds