EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

Procedure Using Synonym Pointing to Database Link  XML

Forum Index » Postgres Plus Advanced Server
Author Message
Jeff_H

Member

Joined: 12 Mar 2009 14:10:03
Messages: 24
Offline


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 )
AS
BEGIN
SELECT SYSDATE FROM DUAL;
END;
/

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?

 
Forum Index » Postgres Plus Advanced Server
Go to:   
Powered by JForum 2.1.8 © JForum Team