SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

rowtype and type for remote table by dblink

592815Jun 6 2008 — edited Jun 6 2008

Hi Friends,

I created procedure in package. I copy (recreated )a table in local database and package work s well. however, when I remove local copy table and map parameter type to remote table by dblink. I got an error message--Error(19,28): PLS-00352: Unable to access another database 'testrote.AGENT_TYPE'
chkagent is table
dblink is databasesec
syntax as
p_agent chkagent@databasesec.agent_type%type
p_agentinfo IN chkagent@databasesec%rowtype,

How to fix this issue?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 4 2008

Added on Jun 6 2008

1 comment

778 views