How to call procedure in Oracle8.1.7 with a out parameter of VARRAY type b

P

pxlei

Unregistered / Unconfirmed
GUEST, unregistred user!
How to call procedure in Oracle8.1.7 with a out parameter of VARRAY type by delphi6 or c++builder5? (100分)<br />I hava create a type UserID_T and a procedure PROCTEST in Oracle8.1.7,
--------------------
CREATE OR REPLACE TYPE UserID_T AS VARRAY (500) OF VARCHAR2(16);

create or replace procedure PROCTEST
(
o_name out Varchar2,
o_sysid out UserID_T
)
is
begin

o_name :='meteorlee';

o_sysid:=UserID_T(NULL);
o_sysid.EXTEND(100);
o_sysid(1):='meteor1';
o_sysid(2):='meteor2';
o_sysid(3):='meteor3';
end PROCTEST;
--------
Now,I want to know how to call the procedure PROCTEST by Delphi6 or C++Builder5?

Thanks.
 
请斑竹帮忙结束该问题
 
顶部