Re: pl/sql compile error

In article <01bfdcb8$735d49d0$a0364f0f_at_bj210276>,   "junfan" <fanjun_at_bigfoot.com> wrote:
> SQL> create table cover_area(
> 2 STATION_ID CHAR(6) references station,
> 3 AREA_CODE CHAR(5) not null,
> 4 primary key (station_id)
> 5 );
>
> Table created.
> SQL> create or replace procedure init_cover_area (station_id char(6),
> 2 area_code char(5)) as
> 3 begin
> 4 insert into cover_area values(station_id, area_code);
> 5 end;
> 6 /
>
> Warning: Procedure created with compilation errors.

Easy. Get rid of (6) and (5) in the argument list.

Whenever you get compile error, type show error to see what's wrong.

--
Yong Huang

(yong321_at_yahoo.com)
(http://www.stormloader.com/yonghuang/)


Sent via Deja.com http://www.deja.com/
Before you buy.