Platform: Oracle 9.2.0 on Solaris 9
This is probably as much a shell script question as Oracle, but it
involves SQL*Plus with a here document, and since there is a lot of
unix expertise here ...

Hi, i am using following code and getting "ORA-06531: Reference to
uninitialized collection" ??
Please let me know...
Thanks,

In case anyone has been waiting for the production version of Oracle DB
10g R2 eXpress Edition - it's released now
The releases are for Windows & Linux using either Western Latin I or
multibyte Unicode char sets.

Do Oracle provide a Download manager (like Sun's Sun Download Manager)
which is specially designed for downloading softwares from Oracle.com?
If yes, please provide download link for the same.
Thanks In Advance

Have a program which is currently processing a cursor and doing various
bits and bobs with the data. Am making a change in which i need to
insert data into a table for each row processed.
My question is would it be better to store this info in a PLSQL table

It is time to download Xg from OracleXg.com

We have just recently installed two servers running Solaris 10 and an Oracle
database (don't know much about version, will need to check further).
Currently, I use Veritas Netbackup 4.5 datacenter for all of our server
backups to a Quantum ATL.  Solaris 10 isn't supported with ...

good morning...
is ti possible catch an exception into a while statement?
eg
while(condition) loop

There are two web applications which locate on different mathcine
servers running on the same oracle 10g database with RAC. One of the
applications works well all the time, the other one also does work well
in the beginning few days, but after few days it will quickly slow

We are running Oracle 9.2.0.7 on AIX.  We are trying to apple the
latest patch:  4759123 - CPUJan2006
We receive the following error from OPatch:
System Command: /ora2/app/oracle/product/9i/jre/1.4.2/bin/java

Each,
Am considering using plsql records purely to group related variables
together in my package. For example i may have variables to do with
subscribtions so would create the following

http://www.computerworld.com/databasetopics/data/software/story/0,10801,108680,0
0.html
Pointed out first on the Informix usenet group where they are watching
a great product, first marginalized, now suffering the death of a
thousand paper-cuts.

Hi, all.
I have a query I have been asked to tune. I'll describe my issue, and
then outline the specifics below.
Basically, several variants of this query are being used. In each

I am thinking about becoming an Oracle developer. I have experience with
Centura Team Developer AKA SQLWindows, this is a front-end developer
environment for a variety of of database servers: Oracle, MS SqlServer,
Informix etc.

    Currently we have 2 databases(one is production and other is
development).  Both are on different servers.  And one user have
userid/pwd for both databases.  But we are trying to connect to oracle
thru SAS application 9 version.  The idea is to block  access to