Need PL/SQL help. Passing PL/SQL tables as parameters.

I am using Oracle 7.3 and have written a procedure that is part of a package and returns PL/SQL tables to the calling environment. For some reason, upon calling the procedure, my program just hangs for hours on end unless I control-break out of it. Even the dbms_output.put statements within my program do not print out.

I am at a loss as to what is wrong. I have written packages before but have never had to use PL/SQL tables as OUT parameters. Can anyone provide me with any info on this? Is it the passing of tables as parameters that's causing the problem? Below is a sample of a short proc I wrote to call my package which returns the PL/SQL tables.

create or replace procedure testpkg
is

Done     integer;
Ret       integer;
A          PKG.PLSQL_Table1;
B          PKG.PLSQL_Table2;
C          PKG.PLSQL_Table3;

begin
PKG.GetData(10,Done,Ret,A,B,C);
end;
/

In case anyone is wondering as to what I'm trying to accomplish, my company is converting from Sybase to Oracle. A Sybase stored procedure can return rows whereas an Oracle procedure can't. Thus, I am trying to mimic the process with the use of PL/SQL tables. Any help or advice will be greatly appreciated. Thanks. Received on Sat Feb 15 1997 - 00:00:00 CST