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

Home -> Community -> Usenet -> c.d.o.misc -> Re: run stored procedure through non-default connection

Re: run stored procedure through non-default connection

From: <andrew2782_at_my-deja.com>
Date: Wed, 12 Jan 2000 00:42:11 GMT
Message-ID: <85gil0$vs5$1@nnrp1.deja.com>


In article <85gf3i$t72$1_at_nnrp1.deja.com>,   oct1pm_at_hotmail.com wrote:
> Hi all,
>
> From Oracle documentation I learned that you can execute a PL/SQL
block
> that is not at default Oracle instance, see below:
>
> "
> PL/SQL Blocks You can execute a PL/SQL block using the AT clause. The
> following example shows the syntax:
>
> EXEC SQL AT :db_name EXECUTE
> begin
> /* PL/SQL block here */
> end;
> END-EXEC;
> ...
> "
>
> My question is: can I also use a stored procedure in the PL/SQL block
?
>
> thanks,
>
> Andrew
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 11 2000 - 18:42:11 CST

Original text of this message

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