My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.