Oracle cursors

From: Ian Jennings <ij_at_microware.demon.co.uk>
Date: 1998/04/29
Message-ID: <354749C7.59821C49@microware.demon.co.uk>#1/1

Hi all,

Does anyone know how to get values *in* to an Oracle SP, please? I can get them out, no problem, but I need to pass in values (complete row at a time) and don't want to have to list 20 or 30 parameters.

I realise that a Table-based record is needed but, from my understanding, on the Oracle side this can only be declared as 'REF CURSOR RETURN xxx%ROWTYPE'. This then won't let me access the record members in the SP.

Any help will be *hugely* appreciated.

TIA

--


************************************************************

Ian Jennings
Microware Data Services

This post is made entirely from recycled ones and noughts


************************************************************

Received on Wed Apr 29 1998 - 00:00:00 CDT