Oracle dblinks

[Kiko]

Hi everyone,
I'd like to ask if I can create a database link from A to B and then create a new one from B to A, because when I create the second one and try to connect via it I receive this message:
TNS:could not resolve service name
Any suggestions how can I fix this problem???
I should say that the first link is working perfect.
Please write to me at my e-mail: [e-mail].
Thanks in advance!

[rkumar]

hi,

Please help me how to get the out put through procedure from parameter in oracle where out parameter is ref cursor.

[cjtaylor67]

Make sure there is a tnsnames entry for the database you are trying to link to on each of your database servers.

[bv_krishna]

hi,

Please help me how to get the out put through procedure from parameter in oracle where out parameter is ref cursor.

Here is an Example:

create or replace package my_package
as
type ref_cursor is ref cursor;
end my_package;

create or replace procedure my_procedure (i integer , my_cursor in out my_package.ref_cursor)
as
begin
open my_cursor for select * from obj_m_actor where m_actor_n_id >= i;
end my_procedure;