Re: Help with PL/SQL error

Sriram Ganesh wrote:
>
> hi,
> I'm a new user of Oracle. Oracle 7.3.2 was newly installed in my workplace and I'm
> trying to write some stored procedures in PL/SQL. The problem is when I compile my
> stored procedure from within SQL PLUS the compiler comes up with an error saying, "SQL
> Statement Ignored.".
> I'm not able to compile even a simple procedure that has a simple SQL statement in it.
> Similarly when I try to use cursors the compile error I get is, "Item ignored". There is
> no error number for these errors. It is just PL/SQL : Item Ignored or PL/SQL : SQL
> Statement ignored.
>
> I have the required privileges because I'm able to execute the SQL statements from SQL
> Plus. Also, I'm able to create and execute a procedure that does not contain any SQL
> statements. I have read the manuals and other books but no help was available for the
> problem I'm encountering. Any help is greatly appreciated.
>
> Thanks,
> GSri.

Post your procedure syntax and maybe we can help... Received on Mon Jul 08 1996 - 00:00:00 CEST