views:

11

answers:

0

We have a stored procedure which I'd like to call from my client:

PROCEDURE p_my_proc(p_id  IN my_table.id%TYPE,
                           p_record IN my_table%ROWTYPE);

In the client I want to call this procedure using TADOStoredProc, but haven't found a way to assign the record to a parameter. I have a TDataSet with the record in it so thought I could try

fsp->Parameters->AddParameter();
fsp->Parameters->Items[1]->DataType  = ftDataSet;
fsp->Parameters->Items[1]->Direction = pdInput;
fsp->Parameters->Items[1]->Value     = myDataSet;

but I get a compile error as myDataSet is a TDataSet, not a Variant.

Is it possible to add ROWTYPE parameters to a TADOStoredProc stored procedure call?