Re: [ask]: what wrong with my store procedure

From: Remco Blaakmeer <remco_at_rd1936.quicknet.nl>
Date: 24 Mar 1999 00:45:01 GMT
Message-ID: <7d9cid$uju$3@rd1936.quicknet.nl>

In article <7cos9p$saf$1_at_fir.prod.itd.earthlink.net>,

"earthlink" <phil_at_amax.com> writes:
> hi, everyone,
> i'm new in Oracle programming.
> i just create some stored procedures.
> some procedures work, some don't.
> can you help me why this storee procedure won't work?

Others have already said what was wrong with this particutal procedure, but let me give you a tip. If you get any compilation errors while compiling a package, try this in sqlplus:

select * from user_errors;

This will list all recently encountered compilation errors.

Remco
--
rd1936: 1:40am up 10 days, 8:04, 8 users, load average: 1.50, 1.25, 1.14 Received on Tue Mar 23 1999 - 18:45:01 CST