When writing SQL scripts for batch execution on UNIX I normally put
"whenever sqlerror", "whenever oserror" at the top, for example
---------------------------------------
whenever sqlerror exit failure rollback

What do I do when I find:
SELECT XXX, YYY, FROM ZZZ ....
WHERE XXX = BindVariable:
in the shared pool,

Accessing table CLASS1 on instance TC6 over dblink TC6. The table
exists in both schemas TC_0002 and TC_0005.
If I connect to instance TC6 as SYS AS SYSDBA, both DESC TC_0002.CLASS1
and DESC TC_0005.CLASS1 work.

If I call DBMS_OUT.PUT_LINE before a long process (loop), the text is shown
after the process. Is it possible to get the text on screen immediately
before the process is starting? I need some kind of flush function.
Regards,

Oh no! not another 12154! This one is different, I promise, and
would really be grateful for any help
---------------------------------------------------------------------------------
MY QUESTION

Hi,
I have a 2 databases, one using 9i and the other 10g. My platform i
Windows 2000 SP3.  (I had upgraded to Windows 2003, but had t
backout the changes because neither database worked.) Anyway the

is there a way to see the progress of a
materialized create/refresh?
I read something about an info in
v$session_longops

I am using oracle 9i.
I just created the servlet to connect oracle, but i am getting the same
error message over and over. with SQL plus, i can login.
u: scott

I am developing a .Net (version 1.1) application in C# for which I need
to connect remotely to an Oracle 9i database server. To accomplish this
I was attempting to use the .NET Framework Data Provider for Oracle
(System.Data.OracleClient.dll). However, this application will be

Can anyone tell me, whether there is any cure to patch 9.2.0.1 to 9.2.0.5
under Windows XP SP2 ?
I have received a long list of processes that disturb the upgrade process. I
thing those processes (like audio or telephony) are not the problem -

I'll be migrating some 8i and 9i databases down the road, so I've just begun
to learn 10g. I installed the server on a windows box and created a new
database with dbca. The dbca requires, and this is supported in the
documentation, that the instance be allocated a minimum of 40% of ...

I'm a new developer for Oracle Forms 9i. I made a table of Security that
contents UserName, Password and Privilege of an specific users and made a
login page for autentication, but I need know how encript password in this
login page.

Can I create a db link ( not public) in user A, then assign it to B?

I was wondering...
Does anyone run Oracle on RedHat and if so, do you backup to tape directly
from RMAN and if so, what backup software and MML do you use?
Just curious...

I wonder if anybody can help. I have a where clause which looks for a string
pattern e.g.
Select * from Table where Instr(String1,string2) > 0
When String1 is less than 4000 characters the query works, when this is