| Passing .net dataset data to DB layer (oracle 11g) [message #662358] |
Wed, 26 April 2017 06:15 |
 |
OraFerro
Messages: 433
Registered: July 2011
|
Senior Member |
|
|
Dear All,
I have a case that I need expert help in, in order to decide on an application layer and DB layer development technique (standard) to follow.
For example, I have a page that takes information from the user as user, user organization, and fund information.
The user enters their info, their organization info, and information about the fund they want.
In my application, I can either:
1- Use a dataset to store all information I need to send to DB (as three datatables in this case)
2- Use XML to do the same
In oracle I can have:
1- one stored procedure that takes an object of type user, organization, or fund and inserts it into DB
2- use XMLTYPE to pass the data example sent in another post:(http://www.orafaq.com/forum/mv/msg/203273/662267/#msg_662267)
Which approach is better and why?
My criteria of evaluation is more secure, more readable code.
Thanks,
Ferro
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
