Databases
StackOverflow2013
Postsdbo
POPython - reading Oracle from Linux or Windows with the SAME code
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPython - reading Oracle from Linux or Windows with the SAME code
    primarykey
    data
    text
    <p>here is a background: We have an Oracle server running on Windows. Years ago I wrote a client (windows) which reads data from Oracle, process, create XML and send it back to the instrument (mass spectrometer) controlling software (running on the same machine as Oracle). Utility was written in C++ as dll with two wrappers: GUI and console (for LIMS). Connection has been done via ADO/ODBC, so you don't have to have Oracle client installed (MS for Oracle ODBC driver works just fine...) Works like a charm for years, but... Now LIMS is migrating to Linux. I have a choice to make:</p> <ol> <li>to write a Linux version and maintain both Win and Linux (which is NOT good), or </li> <li>to write platform independent code (thinking of Python) and live happily ever after.</li> </ol> <p>here is my (poorly formulated) question: <strong>Is it possible to write Python code which reads Oracle data residing on either Linux or Windows PROVIDING no Oracle client installed?</strong> </p> <p><strong>Edit</strong>:reformulating poorly formulated question: <strong>What are minimal changes I have to make for standard Python configuration/lib in order to use the same code on either Linux or Windows for reading Oracle data?</strong></p> <p>All I need just to execute a bunch of SELECT statements, READ ONLY.</p> <p>already done: </p> <ol> <li>understand that it CAN be done in Java</li> <li>Python: I can detect what platform I am running on and branch the code if necessary (I'll do that, but prefer NOT to, may be just a connect string?)</li> <li>looked at Python cx_Oracle, still can't understand if I can use it and have the same code for Linux and Win (writing test right now)</li> </ol> <p>Any inside will be much appreciated. Thanks</p> <p><strong>Edit1:</strong> found a very good starting point: thanks to <a href="https://stackoverflow.com/q/1148472/753117">cx_Oracle and the data source paradigm</a></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USNikiton
    plurals
    1. PL
      singulars
      1. LTLinked
    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
    1. VO
      singulars
      1. POPython - reading Oracle from Linux or Windows with the SAME code
      1. This table or related slice is empty.
      1. VTDownMod
    1. This table or related slice is empty.
 

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