Print Thread
PL/SQL table parameter problem
#6093 02/23/04 08:15 PM
Joined: Feb 2004
Posts: 8
R
recomp Offline OP
Member
OP Offline
Member
R
Joined: Feb 2004
Posts: 8
mad
It would be nice to have someone who could help us how to invoke a PL/SQL function.
One of the parameters of this function is a PL/SQL table the items of which are made up of records.
Our problem is how to invoke this function by Delphi 7. Below you will find an example of our problem.

TYPE TDATAREC IS RECORD(
FID NUMBER(10, 0),
FNAME VARCHAR2(50),
);
TYPE TPLTABLEREC IS TABLE OF TDATAREC INDEX BY BINARY_INTEGER;

function Test(p_Taj in VARCHAR2, pData out TPLTABLEREC) RETURN INTEGER;

Thanks for helping us.

Re: PL/SQL table parameter problem
#6094 02/23/04 09:18 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
This function cannot be called, because PL/SQL Tables of records are not supported. If possible, use a collection object type like a varray or table. These can be passed as TOracleObject instance.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.046s Queries: 13 (0.008s) Memory: 2.4999 MB (Peak: 3.0431 MB) Data Comp: Off Server Time: 2024-05-17 06:41:55 UTC
Valid HTML 5 and Valid CSS