(Garth) This was a strange one. Attempts at recompiling the following package body resulted in this PLS-00801 error.

(Brendan Tierney) In this 5th blog post in my series on using the capabilities of Oracle Text, Oracle R Enterprise and Oracle Data Mining to process documents and text, I will have a look at some of the machine learning features of Oracle Text.

(Martin Berger) Connor McDonald wrote a blog about differences between bind peeking and SYS_CONTEXT in SQL queries.

(Jeff Smith) When using the data modeler, we assume when you add a foreign key, you haven’t already created the ID column.

(Jeffrey Kemp) Juergen Schuster, who has been enthusiastically trying OraOpenSource Logger, raised an idea for the debug/instrumentation library requesting the addition of a standard synonym “l” for the package.

(Natik Ameen) When trying to connect to a node in the Cassandra Cluster using cqlsh, I get the “Unable to connect to any servers. Tried connecting to [(‘127.0.0.1’, 9042)” message.

(Ben) In this article, I explain what the different data types are in Oracle database and everything you need to know about them.

(connormcdonald) I had an observation come to me last week about PL/SQL and populating nested tables.

(Randolf Geist) In the next parts of this series I’ll have a look at the results of similar performance consistency tests performed on a comparable Amazon RDS Oracle cloud database instance.

(Frits Hoogland) It’s general knowledge that the Oracle database is ACID compliant, and that SCNs or ‘system change numbers’ are at the heart of this mechanism. This blogpost dives into the details of how the Oracle engine uses these numbers.