Databases
StackOverflow2013
Postsdbo
POWhat is the best (fastest, easiest, most efficient) way to pass structured data into and out of Oracle
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhat is the best (fastest, easiest, most efficient) way to pass structured data into and out of Oracle
    primarykey
    data
    text
    <p>I want to abstract a large database store (relational, OLTP) from the application layer by having the application consider the database as a service. The natural way of doing this is by calling sprocs, but traditionally these follow CRUD paradigms and in keeping with my abstraction thinking I want to abstract away all knowledge of data structures within the database and concentrate on business process. </p> <p>So instead of having 'Save Invoice' business process be this....</p> <ol> <li>Start Transaction</li> <li>Create Invoice Header</li> <li>For Invoice Line Items <ol> <li>Create Invoice Line Items</li> </ol></li> <li>Commit Transaction</li> </ol> <p>... instead I want to pass into the database structured data representing the invoice.</p> <p>I can pass down an XML document containing the invoice, but this is what I want to avoid on the Database side:</p> <ol> <li>Parsing XML</li> <li>XML Validation</li> <li>Parameter extraction and binding into Oracle PL/SQL objects</li> </ol> <p>Off-course, in all cases, no matter the solution, this must be done. However, I don't want to pay the XML document penalty (the angle bracket tax).</p> <p>Hence the question - what is the most efficient way to send and receive and structure data into Oracle stored procedures?</p> <p>I would like to hear from those who want to argue for JSON, ATOM or other formats.</p> <p>Also consider native or binary mechanisms to achieve this. What about constructing and sending in Oracle tables (memory datasets)? Has anyone done this before? What where your experiences?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USpnuts
    1. UScmdematos.com
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWhat is the best (fastest, easiest, most efficient) way to pass structured data into and out of Oracle
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POWhat is the best (fastest, easiest, most efficient) way to pass structured data into and out of Oracle
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POWhat is the best (fastest, easiest, most efficient) way to pass structured data into and out of Oracle
      1. USRachel
      1. VTFavorite
    1. COthe angle bracket tax? It is not nearly as bad as they want you to believe, especially if you use the right technology... google "fastest XML parser" should give you a good starting point
      singulars
      1. POWhat is the best (fastest, easiest, most efficient) way to pass structured data into and out of Oracle
      1. USvtd-xml-author
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload