This works great:
$ sqlplus smiller/mill@oradev
But connecting to the same db from the same box with this OCCI C++:
   std::string user("smiller");

My pl/sql procedure dynamically generates some sql of the form
    v_sql:= 'Select colA, colB from mytable WHERE colC MEMBER OF :ntt1';
This is fired later as follows
    OPEN po_ref_Cursor FOR v_sql USING ntt1;

I haven't been able to find anything other than 11g specifications yet ...
I remember once seeimg 10g specifications saying the maximum database size
for the Oracle 10g Standard Edition was 500GB.  Is that correct?
Thanks.

Hi M/S:
Here I am selecting simple statement but I am getting ora01722 error.
Can somebory please help me on this.
Thanks in advance.

I wrote a statement that contains a WITH clause:
SQL A: WITH ... AS adata SELECT ... FROM adata
It works fine. Now I wanted to insert the result into a table
SQL B: INSERT INTO tableA (col1, col2 .....) (WITH ... AS adata

I have a query that looks like:
select ...
from tab1,
     tab2,

This site has the best information about the best and the latest
softwares from all over the world and of all types. It also provides
their direct download links.
for more info Visit  http://softwarecollect.blogspot.com

Every time I run the code below, it just hangs.  If I run it in SQL
Developer it just sits there waiting on a response.  Any one have any
ideas why? This is a short version code I have in an application that
opens a file/indexes the text, and it is causing the application to

Hi People,
I am running an Oracle 10G clustered database with ASM hosted on a SAM
system. There are two instances accessing the DB from two different
machines at any given point of time. Now my question is how do we

I am trying (for self educational purposes) to install RAC (11g) on a
laptop using VMware with two guest clients (CentOS5 masquerading as
RHEL5) in a cluster.
Does anyone have an idea what the minimum physical RAM is on the host?

Please find below an error screenshot. The system failed last week and
we did recovery from the
tape backup. Initially, there was error Message 4505 then Control_File
mismatch errors but we

Please find below an error screenshot. The system failed last week and
we did recovery from the tape backup. Initially, there was error
Message 4505 then Control_File mismatch errors but we managed to
bypass all. Now, the database can be mounted but with this error as

Hi, ran into this document which says server managed backup is not
available on oracle XE. But am able to run RMAN. Will that be a
compliance issue, or did I miss something technically
http://www.oracle.com/technology/products/database/oracle10g/pdf/twp_general_10g
db_product_family ...

Visit this site to check all latest and complicated Oracle Interview
questions. Good site which describes most of the Frequently asked and
searched Topics explained. Good and simple tutorial.
http://www.oraclepassport.com

Oracle Applications Developer
Contract to hire
_______________________Seattle_________________US Citezenship or
Permanent residence required