Re: create procedure problems

On Nov 14, 1995 14:48:56 in article <create procedure problems>, 'homayoun sadri <homayoun.sadri.0245197_at_nt.com>' 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
 

Yes, you need to select .. into don't you? Where do you expect the results of your select to go?  

Amy Received on Wed Nov 15 1995 - 00:00:00 CET