Re: Compilation Error (Stored Proc.)

Perhaps someone else will want to go into detail, but you can see what the potential errors are by using

SHOW ERRORS This will give you a start, but keep in mind that errors are cumulative, so one syntax error early in the parsing will cause many other "false" errors to show.

You should really pick up a book on PL/SQL. "Oracle PL/SQL Programming" by Scott Urman is one that I use, but there are many out there.

Philip Fu <cwfu_at_cs.indiana.edu> wrote in message news:813u6o$dm5$1_at_flotsam.uits.indiana.edu...
> Dear all,
>
> I am new to PL/SQL and I encountered the following problem:
>
> Warning: Procedure created with compilation errors.
>
> when I loaded in the folowing file,
>
> ----------------------------------------------
> CREATE OR REPLACE PROCEDURE query3a (
> c1 IN CHAR,
> c2 IN CHAR) AS
> BEGIN
> SELECT *
> FROM ATABLE t
> WHERE t.C1 = c1 AND t.C2 = c2;
> END;
> /
> ----------------------------------------------
>
> Can anyone help me to resolve this problem?
>
> THANKS IN ADVANCE...
>
> Philip
Received on Fri Nov 19 1999 - 13:08:33 CST