Re: PL/SQL Error with stored procedure

Hi,
  Just from a quick scan,
Line 1, change IS to AS
Lines 2, and 3 add ; to end of declaration. Hope that helps.
Cindy Ferguson, Rational Concepts, INC.

Fred wrote:

> Trying to write and execute this simple procedure, I get the following
> error-messages:
> (I'm looged on as User SYS, the table_name is Test)
>
> With the Partitioning and Objects options
> PL/SQL Release 8.0.3.0.0 - Production
>
> SQL> create or replace procedure Get_data Is
> 2 f_txt test.txt%type
> 3 f_bez test.bez%type
> 4 cursor c_Curs is
> 5 select txt, bez from test;
> 6 begin
> 7 dbms_output.enable;
> 8 open c_Curs;
> 9 loop
> 10 fetch c_Curs
> 11 into f_txt, f_bez;
> 12 exit when
> c_Curs%notfound;
> 13 dbms_output.put_line (f_txt
> || ' ' ||, to_char(f_bez));
> 14 end loop;
> 15 end;
> 16 /
>
> Warning: Procedure created with compilation errors.
>
> SQL> SET SERVEROUTPUT ON
> SQL> execute get_data;
> begin get_data; end;
>
> *
> ERROR at line 1:
> ORA-06550: line 1, column 7:
> PLS-00905: object SYS.GET_DATA is invalid
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> ""(column 7 in Error ORA-06550 doesn't say anything to me!!!!!!!!!)""
>
> Trying to track down, I get the following error messages as
> well............
>
> SQL> show errors
> buffer overflow. Use SET command to reduce ARRAYSIZE or increase
> MAXDATA.
> No errors.
> SQL> select object_name, object_type, status
> 2 from user_objects where object_name = 'Get_data';
>
> no rows selected
>
> SQL> select text from user_source where name = 'Get_data' order by line;
>
> buffer overflow. Use SET command to reduce ARRAYSIZE or increase
> MAXDATA.
> SQL>
>
> Your support will be highly appreciated.
> Thanks in advance
>
> Fred
>
> mailto:fredgrasser_at_netway.at
Received on Thu Jun 24 1999 - 02:32:32 CDT