Is It Possible To Pass A ROWTYPE Parameter To A Procedure In JDBC? (Doc ID 2195251.1)

Last updated on MAY 25, 2023

Applies to:

Goal

There is a table and a procedure:
create table test_rowtype (id number, name varchar2(20));

create or replace procedure ins_test_rowtype(p_test_rowtype test_rowtype%rowtype) is
begin
 insert into test_rowtype (id, name) values (p_test_rowtype.id, p_test_rowtype.name);
end ;

Is it possible to pass a ROWTYPE parameter to the procedure in JDBC? If yes, how to implement it in Java code?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.