cancel
Showing results for 
Search instead for 
Did you mean: 

Structure of a data type(Sender JDBC adapter)

Former Member
0 Kudos

Hi Experts,

I've 5 columns. There's a possibility of getting multiple records at a time. How should my source data type look like?

Data type(1..unbounded)

.........Column1(1..1)

..........Column2(1..1)

.

.

.

.

..........Column5

OR

Data type

....Rowset(1..unbounded)

..................Col1(1..1)

..................Col2(1..1)

.

.

.

.

...................Col5(1..1)

Thanks,

Vishal

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Vishal,

The second structure will be a better approach.

You just need to make sure that all the fields (as you have assigned mandatory to each of them), are coming in the incoming payload.

Let us know if you have more queries.

Regards,

Neetesh

Former Member
0 Kudos

Vishal,

Use this one :

Data type

....Rowset(1..unbounded)

..................Col1(1..1)

..................Col2(1..1)

.

.

.

.

...................Col5(1..1)

Col1(1..1)...means each time value will come in this field .., so make it Col1(0...1)...means if value comes it will accept if not o.k..

Regards ,

Former Member
0 Kudos

Hi Vishal,

Take the second structure. Also you have given everything as 1..1 So make sure you have all the fileds come. Since 1..1 if one of the field doesnot come then it fails. So if you are not sure then give 0..1.

Also for reference you can see tihs:

/people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-adapter

Regards,

---Satish