Hi,
I am trying to connect to oracle database using a vb6 application. I have
created a ODBC system dsn for oracle database using "Oracle in OraHome90" as
the driver.  Now using this ODBC Connection , I am trying to connect to the

hi, I try to install 9.2.0.6 rac, and I use 9.2.0.4 package and 9.2.0.6
patch. my platform is rhel3u3
I referenced the article : Step-By-Step Installation of 9.2.0.5 RAC on
Linux(http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_
id=NOT&p_id=184821.1).

I have a server running 8.1.7.4 on HP-UX that was brought down hard earlier
today.  There was an electrical fire and all power was cut abruptly (mains,
UPS, everything).
The system is now back up and the database seems to have recovered.  What

I have an "unussual" problem here:
ORA-00376: file 90 cannot be read at this time
ORA-01110: data file 90: 'L:\ORACLE\ESST\DATA\ESST_CUSTOM_INDEX_7.DBF'
I queried the v$datafiles and see that file being in RECOVER status.

In fact I have two questions! :D
1.How to change a columns data type without making that column empty?
2.How to change the order of columns in a table?
for the 2nd one,I know I can create a new table and do "select into" and...

Dear Sir/Madam
In PL/SQL how can I Find the maximum length of an variable inside the
PL/SQL block
here is my problem (Image only)

i am using Oracle 9.2
I am trying to use Oracle text to search records in a table with a language
key column.
I tried a sample (found in Oracle text documentation "MULTI_LEXER Example:

I am using Oracle 9.2
I am trying to use Oracle text to search records in a table with a language
key column.
I tried a sample (found in Oracle text documentation "MULTI_LEXER Example:

Hopefully, this situation isn't that unique, although I've searched
usenet and haven't found anything that helps as of yet.  I'm running a
pSeries 510 with 4 partitions (1 VIO, 2 AIX 5.3, 1 SUSE 9).    This
system, along with an HMC, will be used for traveling demos.  On one of

I want to write an stored function
which returns an array of numbers.
Afterwards I want to use this function
in an where clause like:

I am learning the DBMS_LOB.
After I've opened a BLOB in my anonymous block, I tried to do something on
it that resulted in an exception.  My close wasnt executed.  I fixed the
error, retry, encountered more exceptions, re-fixed it.  Finally, it says:

Is it possible to display a BLOB column by SELECT in iSQL*PLUS?  I know
there is  a RAWTOHEX() function which accepts both raw & blob types and
converts them to hex equivalent character values.  But I keep on receiving
these errors:

I build my application with -static option on Server A (Linux Red Hat
7.3 and
Oracle 8.1.7.4)
Application work fine :))

I realize that this is probably the stupidest question anyone has ever asked
here, but...  I installed the AdBlock extension to Firefox.  Afterward I
could no longer read the local 8.1.7 Oracle documentation.  The message
"Applet OraInfoNav notinited" appeared.  Uninstalled the ...

I am using ODP.NET to insert data into an Oracle database using the
ArrayBind feature of ODP.NET. I can successfully inserted 51 892 records
with no problems. I get the the following error when inserting 254 456
records; "ORA-24381: error(s) in array DML".