(Bill Hamilton) This article is a discussion of how to access Oracle stored procedures (named SQL programming blocks) and functions (which are programming blocks that return a single value) using ADO.NET. You connect to an Oracle database using managed data providers, including the Microsoft .NET

(Amar Kumar Padhi) This article begins a discussion of how to work with collections. Previous versions of Oracle had limitations for collection usage in regards to SQL statement processing. Bulk Bind and Collect features were introduced to reduce the SQL processing overhead by efficient use of colle

(Mark M. Davydov) As organizations build, deploy, and orchestrate business services using Web Services technology, it becomes apparent that a careful and comprehensive design of Java 2 Platform, Enterprise Edition (J2EE) applications is required. The most effective systematic help in this area i

(Steve Callan) Oracle’s LogMiner utility has been around for several years now, and it originally appeared as a new feature (as opposed to being an improvement of something else). Each major release of Oracle typically ushers in a new set of features, some of which are actually useful and can make y

(Kimberly Floss) One short path to identifying performance problems in an Oracle database is the following: –Find the sessions responsible for hogging the most resources (I/O, CPU, etc.) –Identify the code these sessions are running. –Peel away the bad code these sessions have execute

(Arup Nanda) Some of you may use the dbms_job package extensively to submit database jobs to be run in the background, control the time or interval of a run, report failures, and much more. However, I have a feeling that most of you don’t. The problem with the package is that it can handle only

(Carol Francum) Site expert Carol Francum recently answered your questions on working with Oracle flexfields. She explains how to add a flexfield to a standard form and the challenges of changing flexfield size.

(Ajwat Ul-Hasan) In Oracle9i, this script can restrict users logging into the database. In one table you provide information about which users are allowed to log into the database. You can modify this script to allow or block a user with respect to application, ip address, username, osuser, terminal

(Debu Panda) Here are some common classloading best practices that we have been following and hope useful to many.

Welcome to SearchOracle.com’s Lessons Learned series. Each week you will get a mini-lesson pertaining to a highly-specific database administration, application development, data warehousing and business intelligence, or E-Business Suite topic. At the end of each month, you will be tested on what you