Using %ROWTYPE Parameter

adeptus · Post by **adeptus** » Fri 12 Aug 2005 12:27

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!

Paul · Post by **Paul** » Sat 13 Aug 2005 20:04

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.

adeptus · Post by **adeptus** » Mon 15 Aug 2005 10:26

I did found it out myself...

But nonetheless, thanks for your answer !