Hi,
I have folloiwng types defines in Oracle:
create or replace type position_obj as object
(
POSITION_ID NUMBER,
PROD_TYPE VARCHAR2(50),
);
create or replace type position_tab as table of position_obj;
create or replace type error_logs_obj is object
(
MODULE_NAME VARCHAR2(30),
DATABASE_UNIT VARCHAR2(30),
TABLE_NAME VARCHAR2(30),
ERROR_MESS VARCHAR2(4000),
CREATE_TIME DATE,
USER_NAME VARCHAR2(30)
);
create or replace type error_logs_tab is table of error_logs_obj;
And my Oracle SP is:
PROCEDURE insert_position(p_position_tab position_tab
,o_error_msg_tab OUT error_logs_tab)
How do i call above SP using iBatis 2.3.4 ? Please let me know if its
possible or not.
Thanks & Regards,
Deepak
--
View this message in context:
http://old.nabble.com/Passing-Oracle-Table-Types-%28Is-it-possible-%29-tp28922808p28922808.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
