OraFAQ Forum: Forms » *database Link*

Home » Developer & Programmer » Forms » *database Link*

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

*database Link* [message #85447]

Mon, 28 June 2004 03:37

Robin ( Bangladesh)
Messages: 25
Registered: September 2002

Junior Member

I have created a dblink. but when writing query like

select count(*) from sampe.item_info@dblink

it gives magges and returning no result

ERROR at line 1:
ORA-02085: database link DBlink.world connects to DWH.INCEPTAPHARMA.COM

�

Report message to a moderator

Re: *database Link* [message #85495 is a reply to message #85447]

Fri, 02 July 2004 04:16

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

could you tell me using which statement you have created the dblink?

by
vamsi

Report message to a moderator

Re: *database Link* [message #85502 is a reply to message #85495]

Fri, 02 July 2004 19:09

Robin ( Bangladesh)
Messages: 25
Registered: September 2002

Junior Member

Thanks trying to help me.
I have got the solusion. I missed following statement.
SQL> Alter system set golbal_names=false;

Now it is working.

Report message to a moderator

Previous Topic:	Passing a query from a form to a report on web
Next Topic:	please give a help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 01:42:10 CDT 2024