Re: Stored Procedure problem

I do not know if it the right problem, but I think the RDBMS_OUTPUT package non exists.
Try rename it to DBMS_OUTPUT package.

Vasek Svara
vaclav.svara_at_anfdata.cz

Samuel Wikberger <ia97swi_at_student.hk-r.se> píše v diskusním příspěvku: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 - 04:35:05 CST