Re: create procedure problems

homayoun sadri wrote:
>
> hello to all,
>
> here is the situation; i have all necessary privs, space,and have
 run
> catproc.sql and dbmsstdx.sql and everything is peaches(no errors).
> now when i go to create a procedure like:
>
> SQLDBA> create or replace procedure asdf as
> 2> begin
> 3> select table_name from user_tables;
> 4> end asdf;
> 5> /
>
> i get the following message:
>
> DBA-00072: Warning: PROCEDURE ASDF created with compilation errors.
> SQLDBA>
>
> and when i look in the dba_errors, i see:
>
> SQLDBA> select * from dba_errors;
> OWNER NAME TYPE
> SEQUE
> ------------------------------ ------------------------------
> ------------ -----
> NCE LINE POSITION TEXT
> ----- ---------- ----------
> ----------------------------------------------------
>
> ----------------------------
> HSADRI ASDF
 PROCEDURE
> 1 3 19 PLS-00103: Encountered the symbol "FROM"
 when
> expect
> ing one of the following:
> .
> 1 row selected.
> SQLDBA>
>
> can anyone be kind enough to suggest what is going on here.
>
> thanks in advance
> homayoun sadri
>
> homayoun.sadri.0245197_at_nt.com

Sadri,

Where is your 'INTO' clause?

-- 
Cheers

Sridhar Subramaniam
Avion Consulting Services
Sydney - Australia
Email : ssubrama_at_nibucorp.ccdn.otc.com.au / avion_at_ozemail.com.au

Disclaimer : All opinions are truly and just mine.