I am using ADO accessing Oracle database through the Oracle OLEDB
Provider for Oracle. Since using bind variable is important to Oracle,
I am trying to work out what is the best way to pass them. ADO supports
both Positional and Named variables. Ideally, I would like to use named

I'm using VB to load data from one Access table into a destination table.
At the moment the destination table is also Microsoft Access, so it's a very
simple matter of doing this:
SELECT * INTO tblDestination IN "C:\My Documents\RawData1.mdb" FROM tblSource

I get error when trying to create Foreign Key to a Table, not referring
to a PK But to a UNIQUE Constraint.
I can create FK event not refering to PK as long as that table has
UNIQUE constraint on that specific column, can't I ?

I have a sql performance problem and would appreciate some input to
resolve it.
I operate 2 9i DB instances (1 x Win and 1 x Solaris) and 1 8i instance
(Solaris). Both Solaris boxes are identical in terms of hardware /

I am writing a C/C++ code using MSDEV 2003 and get the
SQL> exec shell('dir');
BEGIN shell('dir'); END;
*

I found this on http://www.orafaq.com/faqphp.htm :
When using the OCI Extension Module, PHP will commit whenever ociexecute()
returns successfully. One can control this behaviour by specifying
OCI_COMMIT_ON_SUCCESS (the default) or OCI_DEFAULT as the second parameter

I'm trying to write a package and in the package header I have this cursor
declared:
 CURSOR c_batting ( p_player_id_char IN in_player.player_id_char%TYPE )
 IS

I am trying to get the result of a query in a php variable
I wander what's wrong with this code because I don't get a value in $val, I
am sure my select is correct as it returns a value in SQL worksheet for
instance.

I need to run a query and have the results published to a csv file.  I am a
relative newbie so any specific help would be much appreciated.  The basic
query below is what I want to export to a csv file.
SELECT

Hi, all,
I'm using Oracle 9.2.0.5 and I can not create an index on a global
temporary table.
I've seen in the news groups where others have done this, but I keep

For those who care about personal notes ... the large IT services
company I work for recently lost their contract to an 'offshore' firm.
I've been here over 21 years, first as an employee of the client
company, then an employee of the services company when the client

If you have a stored procedure in Oracle 9.2 and it returns a result
set, can you see what that result set looks like in SQL+?
Something like:
select * from (ExecProc(MY_PROC_NAME(1,2,3,4))) ?

How can I access a log of the latest queries executed on an Oracle
Database (9i and 10g)?
Thanks.

Has anyone ever used SQL Developer on AIX?  I was able to get it
running on AIX, however I noticed something strange.  If a user is
identified externally, you cannot log into SQL Developer.
As long as the user is not identified externally, he can log in,

I am using Oracle 9.2.0.7 on HP-UX 11i. Is there any possiblity in
Oracle to get an estimation how long a certain query could take time
before I submit it? I can get the cost from the execution plan but I do
not know whether the query would take 1 min or 1 hour.