The “Working with LONG, LONG RAW and VARCHAR2(2000) Oracle Datatypes” white paper is intended to clarify the handling of the Oracle datatypes LONG, LONG RAW and VARCHAR2(2000) when they are used with Microsoft Visual Basic and Remote Data Objects (RDO). A sample project is attached that illustrates

(Debu Panda) I got an email from a customer who wanted to use BLOB data type in their CMP entity bean. They store images in BLOB data types in Oracle database and want to map their CMP entity bean field to a BLOB data type. Manipulation of CLOB and BLOB from J2EE applications is a challenging task.

(Jonathan Gennick) Anyone who works with SQL knows that the results of a SELECT statement are returned in rows and columns. Most people also know that you can easily generate additional columns of data in a result by writing expressions that operate on data that actually is stored in a table. For ex

(Michael Miley) Tony Macedo has a cure for what ails you—if what ails you is the corporate equivalent of multiple personality disorder. He’s built an Oracle-based “identity management” server that he hopes to deliver to each of the 12 directorates at Lawrence Livermore National Laboratory (LLNL).

(Steve Callan) Trivia question of the day: Did Alan Ludden, the host of the 1970’s game show Password, ever use “password” as the secret password? If you missed out on that TV game show classic, not to worry. Oracle has a password game you can play. At one level, the rounds are easy, but in the bonu

(Thomas B. Graves) Oracle Data Pump is a new feature in Oracle Database 10g that enables very high-speed movement of data and metadata between databases. This technology is the basis for Oracle’s new data movement utilities, Data Pump Export and Data Pump Import.

(Bill Brenner) Rob Sherman has never liked Microsoft’s monthly patching cycle. Whether a fix is available or not, he wants to be told about security holes immediately so he knows what to watch for. (R)

(Julien Dubois) Today, unit testing is a very popular technique for ensuring code quality. Thanks to the JUnit framework, it has become quite easy to write unit tests for simple Java applications. However, where real-world enterprise applications are concerned, the typical JUnit testXXX() method wil

(Jonathan Gennick) Recently I wrote about Oracle’s support for hierarchical queries in an OTN article titled Querying Hierarchies: Top-of-the-Line Support. While writing that article, I learned about some exciting, new features in Oracle Database 10g that strengthen Oracle’s already robust support f

(James Koopmann) Improperly sized redo logs can impede the performance of your database and hamper recovery time in the event of a database crash. Oracle has given us yet another advisory that helps us to properly size redo logs, taking yet another tedious task from us.