Simple Create Procedure Problem..

From: Arijit Chatterjee <arijitchatterjee123_at_yahoo.co.in>
Date: 29 Nov 2004 20:55:59 -0800
Message-ID: <ea01504d.0411292055.483975af@posting.google.com>

RESPECTED FACULTIES,
I AM TRYING TO WRITE A PROCEDURE CODE IS GIVEN BELOW

---

CREATE PROCEDURE PROC(ACCNO IN NUMBER)
AS
BEGIN
SELECT * FROM ACCOUNTMASTER WHERE ACCOUNTCODE=ACCNO; END;

---

aND I AM GETTING THE ERROR

---

Warning: Procedure created with compilation errors.

---

I HAVE CONNECTED WITH SCOTT/TIGER AND SCOTT HAS GIVEN THE PRIVILEGES TO CREATE PROCEDURE. NOW WHAT SHOULD BE THE REASON FOR THIS ERROR? REGARDS
ARIJIT CHATTERJEE Received on Mon Nov 29 2004 - 22:55:59 CST