on 08-23-2009 1:30 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.