Joined: 12 Mar 2009 14:10:03
I'm trying to create a procedure that uses a synonym which uses a database link pointing to Oracle.
The db link works fine and so does the synonym. But the following code that tries
to set the datatype of the passed in variable does not work:
CREATE OR REPLACE PROCEDURE testing (p_member_record MEMBER%ROWTYPE )
SELECT SYSDATE FROM DUAL;
ERROR near line 1:
translation for synonym "member" is no longer valid
As I said, the db link works just fine as I can describe the MEMBER table and count(*) from it.
It is only when I try using it above that it doesn't work.
Any ideas here?