Re: Stored Procedure problem

The line stating RDBMS_OUTPUT.PUT_LINE(i.name); is incorrect. Try using DBMS_OUTPUT.PUT_LINE(i.name);

Kevin

Samuel Wikberger <ia97swi_at_student.hk-r.se> wrote in message news:Js4x4.53$2h7.18246_at_newnews.hk-r.se...
> Hi,
>
> I have a problem when I try to create a Stored Procedure in my Oracle8i. I
> have tried the following:
>
> CREATE OR REPLACE PROCEDURE my_proc
> AS
> CURSOR my_cursor IS
> SELECT name FROM Person
> WHERE name LIKE '%c%';
> BEGIN
> FOR i IN my_cursor LOOP
> RDBMS_OUTPUT.PUT_LINE(i.name);
> END LOOP;
> END my_proc;
> /
>
> This won't work and I get an error message that looks something like
> "Procedure created with compilation errors".
> If anyone knows how to solve this problem, I would be very happy.
>
> /Samuel
>
>
Received on Tue Mar 07 2000 - 05:17:04 CST