STORED PROCEDURE WITH OWN PARAMETER TYPE

[kschwarz]

Hello,
i've defined the following in ORACLE for test

create or replace type NUM_ARRAY as table of number;

create or replace procedure give_me_an_array( p_array in num_array )
as
begin
for i in 1 .. p_array.count
loop
dbms_output.put_line( p_array(i) );
end loop;
end;

Now i try to call the stored procedure from Delphi like this:

OraSession.OCICallStyle;
MyType := TOraType.Create(OraSession.OCISvcCtx, 'NUM_ARRAY');
MyObject:=TOraObject.Create(MyType);

I become error message:
OCI function is not linked

I use OraSession directmode, does this only work with oracle client or
whats wrong?

Thanks

[Plash]

OBJECT, ARRAY and TABLE Oracle data types are not supported in Direct mode.