Re: Stored Procedure question
From: Yuri Ivanov <trak_at_trak.spb.ru>
Date: Tue, 18 Oct 2005 23:59:07 +0400
Message-ID: <dj3k6b$2t9$1_at_news.rol.ru>
Date: Tue, 18 Oct 2005 23:59:07 +0400
Message-ID: <dj3k6b$2t9$1_at_news.rol.ru>
sahcutie пишет:
> I am a newbie in oracle and I have written a stored procedure that
> should return multiple records. I have implemented cursors and I was
> wondering if anyone would point out what is wrong. I have pasted my
> stored procedure below:
> Any help is appreciated. Also any links to help me along the path will
> also be really appreciated.
---skip---
A procedures never RETURNs anything, against a functions.
At least, if you want to get something from procedure, you must use IN
OUT parameters. :) Or use CREATE OR REPLACE FUNCTION
Sure.
Received on Tue Oct 18 2005 - 21:59:07 CEST