Oracle

This error occurs while skipping any bind variables .But it will work fine ,When I set all the bind variables

Recently we received several questions regarding an unusual situation where a SQL Statement has hundreds of child cursors. This is in fact the expected behavior when CURSOR_SHARING is set to similar Bind peeking is in use And a histogram is present on the column used in the where clause predicate of query You must now [...]

I’m in the middle of updating Expert Oracle Database Architecture Edition 1 to Edition 2. It’ll cover up through Oracle Database 11g Release 2. While doing it, I’ve been discovering that “things change over time”. Well, Ok, that is not a new discovery – I’ve said that before… If you are interested in the new [...]

We promised in an earlier post to cover some of the questions from the Optimizer round table discussion at Oracle Open World. Here’s our first in a series of posts that will address these questions. Q: When moving from 10g to 11g, should hints in existing SQL be removed? A: I was glad to see [...]

Yesterday in my course I ran into a strange BUG in Oracle Express (XE) on WIN32 and Linux 32 bit, in fact one of my students,  Ralf Spiwoks, found it: I have tried to run a  top level anonymous block in which assigned a value to a BIND variable and got kicked … Link to the [...]

I’ve added example# 148 to illustrate a technique to declaratively initialize the bind variables of a view object at task flow startup time. Link to the original site

Instrumentation Cary Millsap has recently pointed to a couple of postings and quoted some people on the fine art of instrumentation.  He quoted me (and got it pretty much 100% – dead on) a couple of times as well.  I’ll add a quote/story to his list of quotes… When Oracle 10g first was released – [...]

When you migrate your ADF 11.1.1 application to 11.1.1.1, if you happen to have attributes with names like Category, Reference, PropertyValue, Sequence, or several others, then you may notice that your application malfunctions where it references these attribute names in Groovy scripts/expressions. One situation where the problem occurred for me was in a bug tracking application [...]

In response to a question asked on the dBforums website, I created a little screencast to show the simple steps to go from a SQL query that you’ve got working in SQL Developer to a JSF page that display its results and allows the user to enter values for its bind variables. Using a SQL [...]

Recently we received several questions regarding a usual situation where a SQL Statement has hundreds of child cursors. This is in fact the expected behavior when CURSOR_SHARING is set to similar Bind peeking is in use And a histogram is present on the column used in the where clause predicate of query You must now [...]