Re: PL/SQL Catch*22?

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: 1997/11/13
Message-ID: <I2CWJJADU2a0EwaI@ahardy.demon.co.uk>#1/1

In article <346b3674.2895911_at_news.teleport.com>, "Jonathan W. Ingram" <jingram_at_spam.less.teleport.com> writes
>On Fri, 07 Nov 1997 21:35:48 -0500, Jerry Apfelbaum <japfelba_at_ican.ca>
>wrote:
>
>>Thanks Dan. What you say is of course correct. The drawback to me is
>>that it becomes virtually impossible to do the nice PL/SQL cursor
>>operations like the CURSOR FOR loop.
>>
>>Incidently, do you have any experience with this following problem: Can
>>DBMS_SQL run SQL queries where the tables are mapped through synonyms?
>>I can't seem to get them to work in DBMS_SQL although they work just
>>fine the usual way.
>I don't know what version you're running, but you might consider using
>a REF CURSOR.

Can you use a REF CURSOR in a cursor for loop?

Andy
Andy Hardy. PGP key available on request

Received on Thu Nov 13 1997 - 00:00:00 CST