Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Calling a procedure.
<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
![]() |
![]() |