Re: Package Cursor Question

From: E Richard Leiman & Eva <emad100_at_earthlink.net>
Date: Thu, 27 Mar 2003 10:58:16 GMT
Message-ID: <cPAga.21896$jA2.1963073@newsread2.prod.itd.earthlink.net>

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 Received on Thu Mar 27 2003 - 04:58:16 CST