procedure create with compilation error ora-6550
i created table staff with two column a number(3),b number(3) then created procedure p1 but it shows error as procedure created with compilation error & during insert ORA-6550 error at line 1 column 7
create table staff(fno number(3),lno number(3));
create or replace procedure p1 (a in number,b in number) begin insert into staff(fno,lno) values(a,b);
end p1;
execute p1(1,2);,
Software/Hardware used:
create table staff(fno number(3),lno number(3));
create or replace procedure p1 (a in number,b in number) begin insert into staff(fno,lno) values(a,b);
end p1;
execute p1(1,2);,
Software/Hardware used:
ASKED:
June 17, 2010 7:15 AM
UPDATED:
June 17, 2010 4:30 PM
Answer Wiki:
You are missing the 'IS' (or 'AS') keyword:
<pre>create or replace procedure p1 (a in number,b in number) <b>is</b>
begin
insert into staff(fno,lno) values(a,b);
end p1;</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
