Skip to content

Content Tagged "cx_oracle"

Page 1 of 1

Drop an Oracle-Loaded XSD in Python

March 31, 2014Category: Software
A loaded schema can be dropped if: No other schema depends on it No data using the schema is loaded I think you may force unloading schemas even if there is data loaded but I haven't tried that. The code to drop a schema is: You can use it if e.g. schema is updated or we don't need it anymore. The…

Loading Dependent XSDs in Oracle through Python

March 31, 2014Category: Software
One essential feature is that schemas can refer to other schemas. Oracle supports it via the schemaURL parameter. In other words, the url of the referred schema must be the same as the schemaURL parameter used to register the referred schema. One consequence of this feature is the necessity to…

UPSERT (update or insert) in Oracle with Python

March 24, 2014Category: Software
One of the things I had to do is to build a script to upload data (e.g. the content of a list of files) into a database with a single table. My table has 3 columns: ID - a 20-character string identifier with PK properties (unique) ARTICLE - an XMLType element with the article details CITEDBY - an…

Memory dump: Work with XMLField in Oracle (part 3)

March 6, 2014Category: Software
TL;DR: Here I present how to insert data with python in the table created at the previous step. Table of Contents Part 1 - Prerequisites Part 2 - Create a table and perform a SELECT Part 3 - User Python to insert data Part 4 - references In the previous entry, I've finished by creating the table…

All tags