Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to pass % Rowtype parameter from Java to Procedure?

user10264958Mar 13 2013 — edited Mar 13 2013
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 10 2013
Added on Mar 13 2013
2 comments
3,652 views