How to pass struct with array attribute from Java to SQL stored procedure?

Question

I have some types in Oracle.

create or replace
TYPE r_telefone_cand AS OBJECT (
    candidato NUMBER(10,0),
    telefone VARCHAR2(15)
);

create or replace TYPE t_telefone_cand AS TABLE OF r_telefone_cand;

create or replace
TYPE r_candidato AS OBJECT (
    codigo NUMBER(10,0),
    rg VARCHAR2(15),
    cpf NUMBER(15,0),
    nome VARCHAR2(50),
    telefone t_telefone_cand,
);

And I have a procedure insert_candidato that parameter candidato is IN r_candidato

create or replace
PROCEDURE insert_candidato(
    candidato IN r_candidato
) AS ...

But I don't know how to pass the parameter candidato with the collection telefone.

Please, help me.

Ratna Dinakar · Accepted Answer · 2011-06-17 04:50:22Z

1

Give a try using JPublisher of Oracle.. !

http://download.oracle.com/docs/cd/B10500_01/java.920/a96658/intro.htm

It helps in interacting with user defined DB objects through Java.

answered Jun 17, 2011 at 4:50

Ratna Dinakar

1,57313 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

aar · Accepted Answer · 2011-08-17 18:23:08Z

1

You can use SQLData to map a java class to an oracle User Defined type. Check out the docs at http://download.oracle.com/javase/1.4.2/docs/api/java/sql/SQLData.html

In your case you'd need two types to match the db types.

answered Aug 17, 2011 at 18:23

aar

3221 silver badge7 bronze badges

Collectives™ on Stack Overflow

How to pass struct with array attribute from Java to SQL stored procedure?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related