Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SV: Stored Procedure problem
Thank you very much for the help!
Now it works fine, I looked at a non-working example...
/Samuel
Kevin Bass <akil1_at_mindspring.com> skrev i
diskussionsgruppsmeddelandet:8a2ofp$s3g$1_at_slb0.atl.mindspring.net...
> 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 - 07:59:37 CST