I have a simple problem which needs a probably not so simple solution:
I am customizing an application that accesses a database (in this special
case Oracle 9i), and I need to react after this application adds data to a
specific table.

I'm trying to call a simple Oracle stored procedure (which I created and
which uses the DBMS_OBFUSCATION_TOOLKIT) from my Java code, but am
having problems.
Here's my stored procedure:

Tell me...
Why are all the responses on this group so harsh?
Is it job security that you talk down to people so that they don't get into
Oracle?

Hi DBAs,
we've got 3 x 9.0.4.1 Oracle Apps Servers connecting to an Oracle
9.2.0.4 database. Unfortunately, not enough time was set aside for
stress-testing...

I need some info regarding the " Capacity Planning for database  "
in a OLTP based application . Typically it's a  3-tier architecture
(web - app - db).I have to develop a design template for this.
The sub-systems which have to be keep in concern are

Oracle has a Certification matrix available at
http://metalink.oracle.com/metalink/certify/certify.istore_welcome that
tells us what software has been certified on what OS with what patch
level etc.

i am preparing for my first ocp exam and am having a little difficulty
understanding the concept of indexes. the book says:
"b-tree indexes can be used if any combination of leading columns of
the index is used in the SQL statement"

Any news yet ? Wasn't this release planned for June ?
Matthias

As this technology was invented in the Oracle 9i. But in the Oracle 10g
the DDL flashback was introduced, as with the recycle bin funda. I am
creating a index on the table and then when I am deleting the index the
index is been not seen in the recycle bin, But it is seen in the

Hello Experts
I am new in Sql triggers and i would like some help
I have a Table called ITEM and another callded SOURCE
[ITEM]

AIX 5.1
Oracle 9.2.0.5 RAC configuration
EMC SAN
Ocationally there are performance issue with the db. Some jobs become very

How I can substract two dates, and to know the number of seconds
between the two dates?¿

Hi, there used to be a fellow that regularly spammed this newsgroup for
something called OMLET. His name was Amjad Daoud Abdullah. He was shot and
seriously wounded just under two months ago.
http://imemc2.thinkhost.net/index.php?option=com_content&task=view&id=10123&Itemid=51

I'm trying to use the instantclient for odbc.
I've installed everything, base in c:\oracle\instantclient10_1,
odbc addon as well, did the .bat file
and now I'm trying to connect to my database.

Description:   The BEST ORACLE DBA's discussion group.
Post your queries,ideas,share knowledge.
Solaris/Unix queries allowed too;keeping mind the very fact that the
line between Sysadmins and DBAs is diminishing!!