Send a (cursor) as (IN parametre) from an Toracledataset.

[helmis]

Hi

How to send a (cursor) as (IN parametre) from an Toracledataset ?

example :

PROCEDURE TEST (Tcur IN OUT Tcur);

Thanks

 

[Marco Kalter]

Is this an input cursor (passed into the procedure, which then processes the result set) or an output cursor (opened in the procedure and passing the results back to the caller)?

 

[helmis]

example

In oracle

-- Create table
create table Person
(
Name varchar2(10),
Country varchar2(10)
)
;
////

create table Cursus
(
year number,
job varchar2(20),
name varchar2(10)
);

foreign key (NAME)
Person (NAME)

///
in Delphi

Tperson = class
Name : string
Country : String
Cursus : Toracledataset
procedure Save;

I want to save my class in commit if and only if all recordcount in the oracledataset are recorded successively otherwyse I make a rollback.

I did not find a solution other than to send a cursor in parameter in a function

and the cursor here is the oracledataset

 

[Marco Kalter]

I'm afraid I do not understand what you are asking. I see no cursors in your example.