I've written some types that contain pl/sql static functions that
generate instances of these types (what I would call constructors in an
object oriented programming language).
What I'm observing is that, although I only execute the function once,

The SQL_TXN_SERIALIZABLE transation isolation mode of ODBC is something
similar to OCI_TRANS_SERIALIZABLE mode in OCI.
Similarly do we have any modes in OCI, which corresponds to the
isolation levels SQL_TXN_READ_UNCOMMITTED, SQL_TXN_READ_COMMITTED and

i have no experience on application server 10g and i got job for
deploying froms 6i and reports on 10g application server release 2 i
have done oracle 9i dba course,but no idea about application server,if
any body guide me for deploying forms and reports.and tell me the step

I have a problem with GetRecordCount() in VC ..
When I execute SP returning multiple rowset using ref_cursor, this
process is succeed in excuting. But the result of GetRecordCount is -1.
If the result of SP is NULL and then I excute MoveFirst() or

I try to get the user program name which is connected to Oracle 9i. I
can't use V$SESSION. I didn't find anything in sys_context() function
pour the program name. How can I get this information ?
Thanks

I read in the fine Database Backup and Recovery Advanced User's Guide
(10.2.0.1), that
for using the BLOCKRECOVER feature...
"You must have a full RMAN backup. Incremental backups are not used by

I would like to know when exactly the implied commit takes place in a
plsql block.
for example:
BEGIN

I want to setup history tables for some of my production tables. These
tables should reflect all changes on the respective main tables. My
idea was to locate these history tables in a separate schema, where
every history table has exactly the same layout as the corresponding

Can anyone tell me how to migrate tables from mysql to oracle ? I have done
it using the oracle migration tool.Is it possible thru  SQldump ?
Thanks In Advance
Jai.

Hello, I'm using the oracleclient namespace to attempt to connect to a
Oracle 8 db on a server.
I have the following code:
try

our applications - or some of them - are generating more data than our
hardware can stomach.  The question is of course which ones.  Should be
easy to answer if I can determine which tables are written to most.
Don't tell me to RTFM, I know all about the F, and I'm starting with ...

I have to move an oracle 8i database from one server to another server
(bigger, newer and has more RAM). I have to do it with minimum
downtime. If you have to do it, how would you do it?
Assume that the old and new servers are the same except for:

Oracle Buys The Catholic Church
VATICAN CITY (AP) -- In a joint press conference in St. Peter's Square
this morning, ORACLE Corp. and the Vatican announced that the Redwood
Shores, CA software giant will acquire the Roman Catholic Church in

is it somehow possible to find all sequences known in a schema,
preferably using JDBC methods but SQL-queries to find those are also
welcome.
Tom

I am using Apache HTTP server v. 1.3.22 (as packaged with Oracle9i).  I
would like to be able to use iSqlPlus from locations other than my own
machine.  I am using a solitary machine in my home, running XP Home w/
SP2