cx_oracle - Laur's blog

Sign in Subscribe

cx_oracle

A collection of 4 posts

Drop an Oracle-Loaded XSD in Python

Drop an Oracle-Loaded XSD in Python

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: dbms_xmlschema.deleteSchema(

Loading Dependent XSDs in Oracle through Python

Loading Dependent XSDs in Oracle through Python

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

UPSERT (update or insert) in Oracle with Python

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: 1. ID - a 20-character string identifier with PK properties (unique) 2. ARTICLE-

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

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

TL;DR: Here I present how to insert data with python in the table created at the previous step. Table of Contents 1. Part 1 - Prerequisites 2. Part 2 - Create a table and perform a SELECT 3. Part 3 - User Python to insert data 4. Part 4