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?