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

Last updated on JUNE 23, 2017

Applies to:

JDBC - Version 11.2.0.4.0 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms