are.com> cc:
Sent by: Subject: supplying dblink name to
package at runtime
Bill - My guess is that part of the package compilation is to verify the
dblink as well as other objects, exist (for our own protection). What are
you trying to accomplish? Select the destination dynamically? Just a dumb
suggestion, maybe you can accomplish your task by creating a synonym and
then
Bill,
Not sure about the refcursor thningy you mentioned.
I think I would do it another way.
Always have a db link available at compile time for your package. The link
may simply point back to a user in the same database. The thing to do is to
make sure a dblink exists, and that it currently i
Hi
You can use native dynamic PLSQL (8.1 or higher) to do this
stmt varchar2(2000);
stmt := 'INSERT INTO mm_product_temp (rec, rec_old, name, is_disabled,
is_workingcopy)
(SELECT mm_product_seq.nextval, rec, name, is_disabled, is_workingcopy
FROM mm_product@'||v_dblink||' WHERE last_update IS nu
Hi,
I'm trying to incorporate a procedure in a package that needs to run using a
dblink name supplied at runtime. The dblink is used in the dml inside the
procedure, but when I compile the package I get "ORA-00942 table or view
does not exist" for all the sql referencing the dblink.
Here is a co