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.
--------------------
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.