将对象从 Java 传递到 Oracle 过程 [英] pass object from Java to Oracle procedure

问题描述

要将数组传递给 oracle 过程，我们使用 ArrayDiscriptor 和 ARRAY 对象.我必须使用哪些对象来将对象传递给存储过程?

To pass an array to oracle procedure we use ArrayDiscriptor and ARRAY objects. What objects do I have to use to pass an object to a stored procedure?

推荐答案

ArrayDescriptor 和 ARRAY 类(以及 StructDescriptor 和 STRUCT)映射到 Oracle TYPES - 即创建的对象类似于...

The ArrayDesciptor and ARRAY classes (as well as StructDescriptor and STRUCT) map to Oracle TYPES - i.e. objects created something like...

create type my_obj as object( id varchar2(x), etc );

如果您可以访问 java，您应该能够看到 ArrayDescriptor 的构造位置并从中获取数据库类型名称.

If you have access to the java, you should be able to see where the ArrayDescriptor is constructed and get the database type name from that.

您可以将这些 oracle 类型用作函数和过程的参数.

You can use these oracle types as parameters to functions and procedures.

这篇关于将对象从 Java 传递到 Oracle 过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！