Devart Forums

Hi,

Assuming I have a Package wich offers the following Procedure:

PROCEDURE InsertWertpapier(rec IN OUT sev.WERTPAPIER%ROWTYPE) IS
BEGIN
INSERT INTO SEV.WERTPAPIER
(WER_WKN, WER_BEZEICHNUNG)
VALUES
(rec.WER_WKN, rec.WER_BEZEICHNUNG);
END;

How do I use the TORAPackage-Component in a way to fill the Param Rec from Delphi? I know how to create a TORAPackage and I know that I have to call ExecProc but how do I fill then Parameter "Rec"???

I keep getting the "Unknown Datatype" Error... Help...

Thanks for answering!

ODAC and OCI does not support RECORD type. You must write PL SQL block in TOraQuery or TOraSQL and construct your record from simple types before passing it to procedure.

I did found it out myself...

But nonetheless, thanks for your answer !