Use external table in Forms 4.5

[jcasas23]

I declared a dblink from server1 to server2, but i do not know how to use inside Oracle Forms 4.5.

I know that using PL/SQL the sentence working as follow:

select *
from table_name@dblink_name

but I tried to do this in forms and did not work.

Anybody knows the rigth way to do this?

thanks in advance.

 

[sem]

This works in Forms the same way. Do you get any errors?

Regards, Dima

http://seminihin.narod.ru

 

[jcasas23]

Forms 4.5 shows me this error

Error 356
table_name@dblink_name must name a table to which the user has access.

Regards

 

[sem]

This means that you have no access to that table. Can you query it from sql*plus with the same credentials?

Regards, Dima

http://seminihin.narod.ru

 

[jcasas23]

Yes, I can access using TOAD or sql*plus but I cannot uing forms. Is anything missing?

regards

 

[sem]

Try to create a synonym and reffer it from Forms. But as far as I remember I worked with dblinks from 4.5 without any problems.

Regards, Dima

http://seminihin.narod.ru