Re: Not stored "stored procedure".

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Mon, 17 Jan 2005 18:54:33 +0100
Message-ID: <frunu0tnbvnaop86loi4slki9vvlrhn07e@4ax.com>

On 17 Jan 2005 09:34:44 -0800, "Serguei" <gumenyuk_at_canada.com> wrote:

>Dear Experts,
>I have to test a stored procedure without inserting it's codes into a
>database. How can I do this trick in Oracle?
> Regards,
> Serguei.

convert it into an anonymous begin end block and run it through sql*plus. Parameters can be replaced by VARIABLES but of course they would need to be prefixed by a colon in the actual code.

--
Sybrand Bakker, Senior Oracle DBA

Received on Mon Jan 17 2005 - 11:54:33 CST