procedure create with compilation error ora-6550

5 pts.
Tags:
CREATE TABLE statement
ora-6550
Oracle error messages
Syntax errors
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);,

ASKED: June 17, 2010  7:15 AM
UPDATED: June 17, 2010  4:30 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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>

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following