Re: Pointer Cursor on Oracle Forms 5

From: Patrick Wolf <patrick.wolf_at_telekabel.at>
Date: 1998/04/18
Message-ID: <35390d11.5251671_at_news.telekabel.at>#1/1

Hi,

if you do a normal select statement, a ref cursor will not reduce network traffic. Use ref cursors if you like to "hide" your select statements in a package. A other problem with ref cursors is also, that they do not support dynamic sql, so you can only use it with a predefined cursor (that means a fixed where clause!!!).

If you still like to use a ref cursor, I can provide you help. BTW there is an example available from Oracle. Look into the 'Benefits & Features' demo.

Patrick

On 14 Apr 1998 22:27:19 GMT, "Maria" <loriga_at_hotmail.com> wrote:

>How i can use pointer cursor in oracle forms 5 to reduce network traffic
>when execute a table query like:
>
>SELECT empno,ename
>FROM emp
>CONNECT BY PRIOR empno=mgr
>START WITH mgr IS NULL;
>
>How i can use de REF CURSOR in a supplied package???
>
>Help me, please

---

Patrick Wolf
Working for Scientific Games, Vienna

E-Mails: patrick.wolf_at_telekabel.at (home)

         wolf_at_scigames.at (work) Received on Sat Apr 18 1998 - 00:00:00 CEST