Home » Infrastructure » Windows » Passing .net dataset data to DB layer (oracle 11g) (11.0.2.10)
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
Previous Topic: problem in interface of customized application
Next Topic: How to install microsoft oledb for oracle on 64 bit windows server 2012
Goto Forum:
  


Current Time: Thu Mar 28 03:11:21 CDT 2024