Re: dbms_sql and stored procedures

From: Czesław Gryzik <gryzio_at_wasko.gliwice.pl>
Date: Thu, 20 Aug 1998 10:07:27 +0200
Message-ID: <35DBD93F.3DF1BB0A@wasko.gliwice.pl>

I have very similiar problem but also I need to run procedure/function with parameters, and use it outputs.

How can I handle that?

Thanks for any advice.

Kevin P. Fleming wrote:
>
> "execute" is an SQL*Plus command, not a PL/SQL command. To do this properly,
> your v_proc variable should be built like this:
>
> v_proc := 'begin; ' || c1rec.proc_name || '; end';
>

---

Czeslaw Gryzik             e-mail c.gryzik_at_wasko.gliwice.pl
P.W.P.T. Wasko sp. z o.o.              tel.+48 32 230 67 21
ul. Akademicka 3A                      fax.+48 32  31 49 99

44-100 Gliwice

---

Received on Thu Aug 20 1998 - 03:07:27 CDT