Re: Oracle cursors

From: Ian Jennings <ij_at_microware.demon.co.uk>
Date: Thu, 30 Apr 1998 15:29:30 +0100
Message-ID: <35488AC9.200BE8A1@microware.demon.co.uk>

Henk de Wilde wrote:

> >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

 Hi Henk,

Tried that as well. Unfortunately I need to INSERT, not SELECT. Can't do that with a cursor. Spoke to Oracle this morning and they tell me that the Oracle API does not support what I am trying to do.

Back to lists of fields for input.

Unless someone knows different........ :)

Thanks

--

---

Ian Jennings
Microware Data Services

This post is made entirely from recycled ones and noughts

---

Received on Thu Apr 30 1998 - 09:29:30 CDT