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: Calling a procedure.

Re: Calling a procedure.

From: Igor V. Podolsky <igoryok_at_soft-review.kiev.ua>
Date: Mon, 7 Feb 2000 14:00:45 +0200
Message-ID: <AADEhduS80b@soft-review.kiev.ua>


<thezig_at_my-deja.com> wrote in message news:87lb1d$mjn$1_at_nnrp1.deja.com...
> I am trying to find a way to call a PL/SQL procedure if the name of the
> procedure to be called is stored in a VARCHAR2. Any help would be
> appreciated.

You'd use dynamic SQL. It's implementation depends on Your server version. See You documentation for details. Common way for all versions - DBMS_SQL package.

--
Is There A God Or Any Kind Of Justice Under The Sky... (Queen'91)

Igor V. Podolsky (igoryok_at_soft-review.kiev.ua) Received on Mon Feb 07 2000 - 06:00:45 CST

Original text of this message

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