我的包有问题,它看起来像:
create or replace
PACKAGE pac AS
TYPE A IS RECORD
(
aa VARCHAR2(255)
);
TYPE B is ARRAY(1) of A;
PROCEDURE proc1( som OUT B);
然后当我创建主体时它失败,这个记录类型有问题..
我这样做是因为然后在java中我做了
call = connection.prepareCall(...);
call.registerOutParameter(1, Types.ARRAY,...);
call.execute();
array = call.getArray(1);
I have problem with my package its looks like:
create or replace
PACKAGE pac AS
TYPE A IS RECORD
(
aa VARCHAR2(255)
);
TYPE B is ARRAY(1) of A;
PROCEDURE proc1( som OUT B);
then when I'm creating body its fails, there is problem with this record type..
I'm doing this that way because then in java I made
call = connection.prepareCall(...);
call.registerOutParameter(1, Types.ARRAY,...);
call.execute();
array = call.getArray(1);
您的示例包代码不是语法上有效的 PL/SQL 代码,并且您没有提供错误详细信息。这是我的猜测你想要做什么:
另请参阅 Oracle 的有关 "="">PL/SQL 包。
Your example package code is not a syntactically valid PL/SQL code and you don't provide the error details. Here is my guess what you're trying to do:
Please see also Oracle's documentation about PL/SQL packages.