Skip to content

Content classified under "Software"

Page 18 of 21

Loading XSDs into Oracle through Python

April 2, 2014Category: Software
Following the previous incursions in Oracle and their own documentation, we decided it was useful to attach schemas to the inserted data, just because only XML with schemas attached can be indexed. When you have some million entries, indexing seems like a good idea (once you decide what to index…

Use Oracle's RegisterSchema with Large Schemas (from Python)

April 1, 2014Category: Software
An important note when loading XSDs in Oracle is that DBMS XMLSCHEMA.registerSchema() requires the actual content of the _ xsd is loaded in a string. A side effect is that strings in Oracle have limits and schemas can exceed those limits. Therefore, such strings must be fragmented. In this case…

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…

Install NumPy in a Virtual Environment on Windows

March 13, 2014Category: Software
Someone told me they use a custom python install named Anaconda on windows because it contains a set of math packages which are difficult to install. In fairness, they're right because any python module with native dependencies is a mess to install from sources (e.g. because you need the same…

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

March 7, 2014Category: Software
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 References for the series Using XQuery with Oracle XML DB XMLTYPE Oracle XML DB Developer's Guide ORA-01461: can bind a LONG value only for insert into a LONG…

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…

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

March 5, 2014Category: Software
TL;DR: Here I present a SQL example from creating the table to performing a SELECT . 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 Table and XMLTYPE Once we've seen that we have XMLTYPE available…

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

March 4, 2014Category: Software
TL;DR: Here I present an introduction of the problem and some prerequisites to check if you have XMLFIELD available. 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 Introduction Recently, I've got a…
PreviousNext

All categories