Hi,
I have been provided a procedure that accepts a row for a table as input %rowtype and performs some validations on the entered data and based on them creates a table of other mandatory fields that are conditionally mandatory. It then returns this table.
This is the declaration
PACKAGE PKG_VALIDATE_TAB AS
TYPE t_Fields is TABLE of VARCHAR2(40) INDEX BY BINARY_INTEGER;
PROCEDURE VALIDATE_TAB ( tab_rec TAB%ROWTYPE,
ERRMSG OUT VARCHAR2,
tab_arg OUT t_Fields) ;
END PKG_VALIDATE_TAB;
Is there any way to call this procedure from java so that
CallableStatement st = DBT.createCallableStatement(stmt, 1);
st.setXXXXX (1, Row);
I am working with ADF so I already have the populated oracle.jbo.row which I want to pass to this procedure. Can someone please help me in this.
If there is some other data type that I can pass, I am willing to modify the procedure also.
Thanks and regards