I am trying to call a oracle stored procedure from the Integration Server using the pub.db:call service.
The stored procedure signature is as follows
CREATE OR REPLACE PROCEDURE wm_testInsProc
(
v_test_varchar2 IN OUT VARCHAR2,
v_test_char IN CHAR,
v_test_number IN OUT NUMBER,
v_test_decimal IN OUT NUMBER,
v_test_date IN OUT DATE)
)
This procedure executes fine. But if I change v_test_char as ‘IN OUT’ in the above proc,then I get the following error
“java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-06512: at “DW.WM_TESTINSPROC”, line 11
ORA-06512: at line 1”
Any pointers will be greatly appreciated
Thanks
Biju