Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL: Run remote package with db_link as variable

Re: PL/SQL: Run remote package with db_link as variable

From: <xtremesparx_at_gmail.com>
Date: Wed, 10 Oct 2007 13:33:50 -0700
Message-ID: <1192048430.157729.253740@y42g2000hsy.googlegroups.com>


Thank you so much. That worked like a charm.

For whatever reason (still got a LOT to learn about PL/SQL) I was getting errors about my var's needing to be defined. They were defined in the very top-level DECLARE so I'm a little confused about that.

However, I just integrated them into the statement assignment part so that they're literal strings when it's run in the execute immediate statement. Not what I had wanted to do exactly but it will work!

Thanks again. Received on Wed Oct 10 2007 - 15:33:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US