JDBC-Adapter-Receiver Calling Stored Procedure with Input-Typ Record

[frank_schmitt3]

Hallo,

I´ m trying calling a stored-procedure with two input-parameter; one of typ record (oracle) and one of type tabel of records. Is this possible (I think there are only types like string, integer etc. possible)? When not is there another possibility to work with that type?

Thanks in advance,

Frank

[Former Member]

Frank,

Have you made this stored procedure work? I am also have the same interface where I have to have a parameter of type RECORD. Please let me know how you resolved this problem.

Thanks

Kalyan

[moorthy]

Hi Frank,

I think stored procedures will not take Array of Records as a Input. If you want to make a loop funtionality etc then JDBC adapter will work accordingly. You need to just call the stored procedure from the JDBC adapter. It will work for the array of records(multiple occurences).

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Alternative option is you can make use of Java Proxy and from there you can call stored procedure ..I think it is possible.. not tried.

Hope this helps

Regards,

Moorthy