Re: Problem running PL/SQL Procedure

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Mon, 04 Aug 2003 15:23:57 -0700
Message-ID: <3F2EDCFC.16B61A10@exxesolutions.com>

Sanna B wrote:

> Hi all,
>
> I am a newbie, trying to run this procedure and get Invalid Procedure
> error.
>
> The procedure compiles without errors and returns the number of
> records as required. When attempting to execute - I get errors. Any
> ideas?
>
> Thanks,
> Sanna
>

Pull 'DECLARE' out of your procedure and spell out the word PROCEDURE.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Mon Aug 04 2003 - 17:23:57 CDT