ret_val := Package_B.[Email Address Removed] Message');

-----Original Message-----
From: EAramayo
[mailto:oracledba-ezmlmshield-x95475079.[Email address protected]
Sent: Tuesday, September 14, 2004 12:15 PM
To: LazyDBA Discussion
Subject: Executing stored procedures through database links


Does anyone know how to execute stored procedures through database
links?

I have two db schemas in two separate Oracle instances:

I have db_schema_A created on instance_A, which is running on physical
box
A and
I have db_schema_B created on instance_B, which is running on physical
box
B.

I created a database link db_link_B in db_schema_A, which points to
db_schema_B on the other physical box.

From a package_A stored in db_schema_A, I am trying to execute a PL/SQL
stored procedure stored in a package_B in db_schema_B.

I tried the following without success (I cannot even compile):

PROCEDURE proc_A
IS
ret_val INTEGER;
BEGIN

ret_val := db_link_B.package_B.func_B('A message'); -- DOES
NOT
WORK

ret_val := package_B.func_B('A message')@db_link_B; -- DOES NOT
WORK

dbms_output.put_line('The return value is: ' || to_char(ret_val);

END proc_A;

Does anyone know if this is possible? If so, what is the syntax?

The error I keep getting is : PLS-00201: identifier 'db_link_B'
must
be declared

I know my db link works because I can successfully do this: Select *

from [Email Address Removed] help will be appreciated, thank you.

Esteban







--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page