I have a c++ program that is called from a c program. There is an
oracle library calling the c program. The c++ library uses extern "C"
so it can be called from the c program. It runs fine from an
executable on the command line, but oracle cannot resolve t he c++

I have a problem in executing native dynamic sql with the truncate
table ddl clause.
I posted a similar problem before but now the situation changed, I
think nobody replied to the previous message because it was about

Is it possible to run more than one RAC instance on the same machine ?
(to be exact : more than one RAC instance on the same IBM P690 machine
partition - AIX 5.2) ?
(we hope so ;)

hello every one
iam looking for oracle forms tutorials
if any one know a good site provide these tutorials please tell me.
thnx alot.

I've googled this to death and can't seem to find a resolution.
I have installed oracle 8i on Solaris 8. All was working well until I
changed the IP of the server (which is necessary), and now I am getting
connection errors. I can no longer perform a successful tnsping (TNS-12545:

I am looking for the PL/SQL equivalent of the VBScript Exec and/or Eval
functions, i.e. I want to be able to dynamically create a statement, then
execute it in the current PL/SQL context, e.g.
declare

Our current database is 8.1.7.4 32-bit on sun sparc server with
solaris 2.6.
we have to clone this on a fujitsu prime power with solaris 2.9
64-bit.

I have an interesting situation that I thought justifies a question to
the group.  I have a distributed view that Unions data from two
different SQL Servers A and B.  Both servers have the exact same data
structure.  The view is something like this...

We are performing some load testing on our application which is
accessing an Oracle 9i database. I have been given a task to identify
the longest running queries during this period. Is there a way for me
to identify these queries (including the query text) or stored

We have several test instances where we would like to convert the test
databases into multiple schemas in one instance. This would save on
the number of servers we have etc.
I have exported the databases and imported them as test1, test2, test3

I have a tree structure which is maintained through the use of a path
enumerated column:
CREATE TABLE items (
item_id NUMERIC NOT NULL,

I have many problems when try to connect MSAccess to an Oracle database, do
you know how to do this (which ODBC driver, what parameters)
Thanks

   First of all, i am really sorry since i dont know where to post
this query.
But i hope that some of u can really answer my query. I am new to
Oracle Database Administration. I have been working as an SQL server

I'm using Oracle 7 and i'm trying to use data returned from an aggregate
function.  I've created a query that returns a list of duplicate records
(duplicates based on a few fields, not just one).  For each of those
duplicate records, I want to link to another table to get further ...

I used to run Oracle 9i on RedHat 8. The machine was
DELL PowerEdge 16000SC, with Xeon processor, 2 CPUs
and 2GB Ram. The problem I was having with it was that
the database seemed to allow on limited number of active