Re: Package Cursor Question

E Richard Leiman & Eva wrote:

> Dear Daniel,
>
> Hi.
>
> I am using:
> Oracle Release 8.1.7.4.1
> Forms Version 6.0.8.18.3
>
> It is not a ref cursor, but here is some text from the book:
> ---------------------------------------------------------
> Consider the following cursor declaration with RETURN clause:
> CURSOR caller_cur (id_in IN NUMBER) RETURN caller%ROWTYPE
> IS
> SELECT * FROM caller WHERE caller_id = id_in;
> The specification of the caller_cur cursor is:
>
> CURSOR caller_cur (id_in IN NUMBER) RETURN caller%ROWTYPE
> while the body of the caller_cur cursor is:
>
> SELECT * FROM caller WHERE caller_id = id_in;
> Can you tell me how to call this from the Forms trigger?
>
> A while ago you were creating an online tutorial course. Is it finished yet?
>
> Thank you in advance.
>
> Truly,
> Richard

Still working on the course but getting close to ready.

I have never seen a construct such as the one you have above with Forms. I will be interested in seeing if someone has the answer.

What is the book you are referring to? Can you provide name and page. Thanks.

Daniel Morgan Received on Thu Mar 27 2003 - 08:39:15 CST