Re: Oracle cursors

On Thu, 30 Apr 1998 07:47:13 +0100, Ian Jennings <ij_at_microware.demon.co.uk> wrote:

>
>Lothar Armbrüster wrote:
>

<snip>
>>
>> create package your_package as
>>
>> type your_rowtype is your_table%rowtype;
>>
>> procedure your_proc(your_row in your_rowtype);
>>
>> end your_package;
>>
>> create package body your_packege as
>> ...
>>

<snip>
>
>Hi Lothar,
>
>Thanks. Yes I've tried that. I am trying to interface to Delphi and it needs
>the table-based record to be declared as a 'RETURN foo%ROWTYPE' (or so it
>would seem). It handles Cursor-based records ok but it's not keen on
>Table-based. Consequently, it doesn't like the 'IN' bit.
>

Then try replacing :

>> type your_rowtype is your_table%rowtype;

with :

cursor c_help is
  select * from your_table;
type your_rowtype is c_help%rowtype;

I hope this helps

Henk de Wilde Received on Thu Apr 30 1998 - 07:42:14 CDT