I have this problem to.
it is one mistery.. because the dblink was correctly created.

See my case:

I have one dblink correctly working because it is used for another procedures.

I try to create one package body with procedures. This PL/SQL codes acess the Dblink, to insert data into tables of other database.

In database 2, i grant the table for the other user.. this user its a user of dblink.

well.. others procedures created.. with others tables workings.. but only two tables dont working. the message its.. Table or view does not exists....

if i try execute the select of example:

DELETE FROM MY_TABLE@MY_DBLINK WHERE
id = MYROWTYPE.ID its work...

but.. i use a rowtype property to insert this data ....

INSERT INTO MY_TABLE VALUES ( myRowType.id, myRowType.propertyCLob1, myRowType.propertyCLob2, myRowType.propertyCLob3, myRowType.propertyCLob4, myRowType.otherId);

its dont work.. but.. if a use fixed values.. its work.. example


INSERT INTO MY_TABLE VALUES ( 1, 'text1', 'text2', 'text3', 'text4', 1);

Where are the problem?

In the rowtype... ( this rowtype are of one cursor.. this cursor execute one select into the accessed database.. with no dblink )

In the dblink?

In the grant of the objects???

Thanks for help.

Bad english.. my language its portuguese..