Title: Blank
Hi,
Does anyone know about the Oracle Certified
Instructor program. I looked in the Oracle site and didn't found
anything.
Regards
Ramón Estévez
(809-565-3121 x
225
- [EMAIL PROTECTED]
Blank Bkgrd.gif
All,
Using Oracle
8.0.5.0.0 Compaq Tru64 v4.f
One of the duhvelopers here
wants to use OCI. I am sure it is installed as part of the server installation
but where do all the relevant files live for him to use. I can only find oci
files in $ORACLE_HOME/rdbms/demo. Is this normal
We are implementing OPS for our production database.We are aware that only
the select statements(query) gets failover in case of a node failure.
But I have been told, to achieve 100%TAF from our application side i.e the
user w/o reissuing a transaction(update and etc) we need to implement
OCI in
Dear all,
I am trying understand the functionality of a tool. This tool uses OCI
calls to the database for its activities. I wanted to know if there is a way
I can log these OCI calls so that I can learn from it.
I read somewhere that there was a OCI spy used for toad, though I could not
Does anyone know anything about an ORA-1043? We are currently getting it
within our OCI layer with the application trying to perform a create table
statement with a select statement. We have issued a tar with Oracle, they
suggested the 81730 patch, which fixed one computer but not another. Now
Using Oracle 8.0.5.0.0 Compaq Tru64 v4.f
One of the duhvelopers here wants to use OCI. I am sure it is installed as
part of the server installation but where do all the relevant files live for
him to use. I can only find oci files in $ORACLE_HOME/rdbms/demo. Is this
normal. ??
Regards
Lee Robe
thing like that. There you will find the library files and the header
files as well as several demos.
Dan
-Original Message-From: lerobe - Lee Robertson
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 03, 2001 10:45
AMTo: Multiple recipients of list ORACLE-LSubject:
OCI
All,
Yes, the doku of OCI should be in the platform-specific part.
oli
[EMAIL PROTECTED] wrote
> > All,
>
> Using Oracle 8.0.5.0.0 Compaq Tru64 v4.f
>
> One of the duhvelopers here wants to use OCI. I am sure it is installed as
> part of the server installation but where do a
Lee,
Our implementation of OCI makes use of the .h files in
$ORACLE_HOME/rdbms/public and also the shared library libclntsh.so in
$ORACLE_HOME/lib. These have to exist as part of the client installation.
If I'm not mistaken, I had to select the programmer option from the list of
instal
Thanks for all the
responses guys
Lee
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereby notified that any diss
Where can I download the OCI drivers from ?I need the drivers
for Unix and NT.
Should I install the Oracle client to install the oci drivers.?
I was told that OCI drivers with JDBC connection pooling helps
to improve the performance.
Can pls anyone comment or contirubute their experience on
entries to all OCI calls. There are windoz equivalents but they are
not as good, if you have money then use softice or if not use gdb.
You could create a wrapper or thin interface for all OCI calls where
your call calls the real OCI function. Then make sure your library is
loaded for the tool. If i
Dear Pete,
Yes , I am sure that helps. My question was not clear enough. But
you have provided me the answer anyway. All I was interested was in SQL
statements. I am not sure if I will understand the OCI calls(I don't
remember seeing one).
I think it is time for me to RTFM. Because
I'm sending this post here, because got no response
in c.d.o.s.
Does anyone have an example how to write an OCI wrapper library, that
Icould replace the Oracle OCI library with my own (renaming original
one).Then whatever OCI call is made, it ends up to my library where from I
can p
I was just updated by the developers, the OCI (ofen) call is performing ONLY
a select statment, not a create table. Would this make a difference?
thanks,
C-
-Original Message-
Sent: Wednesday, June 12, 2002 10:57 AM
To: Multiple recipients of list ORACLE-L
Christine,
Lets see
Christine,
You could be having more than one issue here, which kind of threw me. First
ofen is an OCI 7 call, the V8 equivalent is OCIStmtFetch. If your running
against an Oracle8 or better database it might be wise to upgrade. Second the
programmer passes the number of rows he/she wants
"Turner, Christine" wrote:
>
> Does anyone know anything about an ORA-1043? We are currently getting it
> within our OCI layer with the application trying to perform a create table
> statement with a select statement. We have issued a tar with Oracle, they
> suggest
hi to all!
it's ages now that i'm looking for a
good method for determining the exact
oci version installed and/or used and
i'm still looking.
is there someone out there who has found
"the" solution on how to correctly determine
the used oci version and want to share
Title: OFFTOPIC RE: OCI
O, I want to buy some! Gimme yer click stream, data boy!
||-Original Message-
||From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]
||Sent: Tuesday, April 03, 2001 11:26 AM
||To: Multiple recipients of list ORACLE-L
||Subject: RE: OCI
||
||
||Yes it is. In
The OCI stuff used to be part of the "programmer" option in the client
installation. I don't recall which of the client installation choices
include this, though I know that the full installation does.
Ron Morton
Database Architect / Administrator
Union Switch & Signal I
You can get the OCI drivers from technet.oracle.com or from the CD. On the
CD installation, make sure to select them, they are not selected by
default. In technet, go to http://technet.oracle.com/tech/java/sqlj_jdbc/
and click on Software to get to the downloads. For OCI, you will need to
Hi all,
I have a developper complaining that is C++ with embedded SQL program is
working on DOS but not in Windows XP.
I've never used OCI. This is with Oracle 8172.
The compile runs fine, it's failling at run time on Windows XP but runs fine
oin DOS.
These are the librairies used wh
Hi,
We're testing an oracle
9.2.0.4 database with an oracle 7 client.
This is a C++ client, using OCI to go to oracle.
We see strange behaviour when using a sequence which worked
nicely before. The sequence is not incremented when issueing
"select
res_id.nextval
Hi,
We are migrating from oracle
7.3.4.3 to oracle 9.2.0.4
without changing clientcode which
is built with oci 7
for oracle 7 db. Code gives this error while printing
all bind variables with values such that
I can only conclude all
variables are bound.
Binding doesn't produ
Not sure that I understand quite well what you want to do (catching statements? Some
à la Sybase 'Open Server' ?) but it is possible that what is defined in the OCI FM as
'user defined callbacks' is, partly, what you are looking for (I have never used
them); I *think* I have
à la Sybase 'Open Server' ?) but it is possible that what
is defined in the OCI FM as 'user defined callbacks' is, partly, what you
are looking for (I have never used them); I *think* I have read something
once in the Oracle docs about functions allowing to write a mock Oracle
serve
I'll send you my OCI wrapper. It was written for V8 and it cannot do object
types,
but, on the other hand, it's easy to understand and performs really well. I
wrote it
a few years ago and I didn't have enough time to maintain it.
--
Mladen Gogala
Oracle DBA
-Original Mes
issue here, which kind of threw me.
First
ofen is an OCI 7 call, the V8 equivalent is OCIStmtFetch. If your running
against an Oracle8 or better database it might be wise to upgrade. Second
the
programmer passes the number of rows he/she wants fetched from the database.
Now if in the past that
Hi,
I am trying to retrieve objects from an ORACLE 8i
database using OCI. I have attached some code that I
wrote for the same but it fails at the OCIStmtFetch
call with the error ORA-00932 inconsistent datatypes.
Has anyone worked on such an issue before?
Thanks in advance.
Sid
Can't you just right click on the dll and choose
'properties' to get the info?
Jared
On Saturday 12 January 2002 03:35, [EMAIL PROTECTED] wrote:
> hi to all!
>
> it's ages now that i'm looking for a
> good method for determining the exact
> oci versi
hi jared!
unfortunately not!
1st. because the dispatcher dll's (ociw32.dll for oci7
and oci.dll for oci8) might have a different version
then the underlying "real" oci client dll's.
2nd. because many of the distributed dll's do not
have any version information resource.
Hi gurus,
we would like to connect to 8i databases with jdbc oci driver.
Our environment:
Db servers:
Oracle Standard Ed. v. 8.1.6.1.0 on RedHat Linux 6.2
Oracle Enterprise Ed. v. 8.1.7.0.0 on Windows 2000
Client:
8.1.7 client on RedHat Linux
java version: 1.2.2
CLASSPATH
HI.
I am using OCIConnectionPoolCreate to establish Connection with
database.
When i run through purifier its showing Leak.
The traces are as follows
MLK: 128 bytes leaked at 0x1b7c830
This memory was allocated from:
malloc [rtlib.o]
sltspc
e but I'm desperate for any advice because I don't
have any developers
left with oci-knowledge
Tnx,
Jeroen
-Oorspronkelijk
bericht-
Van: Jeroen van Sluisdam
Verzonden: Wednesday, November 26,
2003 16:40
Aan: '[EMAIL PROTECTED]'
Onderwerp: migration seque
x27;m desperate for any
> advice because I don't have any developers
> left with oci-knowledge
> Tnx,
> Jeroen
>
>
> -Oorspronkelijk bericht-
> Van: Jeroen van Sluisdam
> Verzonden: Wednesday, November 26, 2003 16:40
> Aan: '[EMAIL PROTECTED]'
It's solved. The oci-code
must be changed when going from oracle 7 to
Oracle 8 or 9. When a sequence.nextval is called using
a float_type you get returned
Duplicates. Not only the type of
column returned must be changed but the buffer etc .. also
Thanks,
J
Hi,
We installed 9.0.1.0 and tried to compile and run oci-demos.
These can be compiled but all produce a core when executed.
Details: hp-ux 11.11 aCC 3.037 os and oracle installed both 64 bit
Any ideas about environment-issues are appreciated !
Tia,
Jeroen
--
Please see the official ORACLE-L
> I am trying to retrieve objects from an ORACLE 8i
> database using OCI. I have attached some code that I
> wrote for the same but it fails at the OCIStmtFetch
> call with the error ORA-00932 inconsistent datatypes.
>
> Has anyone worked on such an issue before?
> Thanks i
Hi,
I checked out the cpan website but couldn't find any
such OCI examples that you have mentioned. I would
really appreciate if you could send the appropriate
link.
Thanks,
Sid
--- Steven Lembark <[EMAIL PROTECTED]> wrote:
>
> > I am trying to retrieve objects from an OR
No offense, but you couldn't have looked too hard. 30 seconds on CPAN led me to:
http://www.cpan.org/modules/by-module/Oraperl/TIMB/Oracle-OCI-0.06.tar.gz,
a tar ball with the latest veriosn of the perl module mentioned. That having been said, I don't believe this module has any usefu
fined object retrieval
using OCI. A casual glance over the code shows that
there are no OCI calls like OCIDefineObject,
OCIObjectNew etc. which may be needed to define place
holders for return values on a statement fetch.
I'd appreciate any further comments.
Thanks and regards,
Siddharth.
> Actually this code is written for Oracle8, which I
> believe doesnot support user-defined object retrieval
> using OCI. A casual glance over the code shows that
> there are no OCI calls like OCIDefineObject,
> OCIObjectNew etc. which may be needed to define place
> holders fo
the object at runtime and then
fetch the object.
Looking forward to some more help in this regard.
Regards,
Siddharth.
--- George Schlossnagle <[EMAIL PROTECTED]>
wrote:
> > Actually this code is written for Oracle8, which I
> > believe doesnot support user-defined object
> re
; retrieval
> > using OCI. A casual glance over the code shows
> that
> > there are no OCI calls like OCIDefineObject,
> > OCIObjectNew etc. which may be needed to define
> place
> > holders for return values on a statement fetch.
>
> I believe that oci8 support
- Original Message -
>
> Exception in thread "main" java.lang.UnsatisfiedLinkError:
> get_env_handle
>
Metalink Note 157468.1 may be helpful:
===
fact: Oracle Server - Enterprise Edition 8.1.7
fact: Oracle JDBC/OCI Driver for JDK 1.2
fac
Hi
One of our developers are planning to migrate from 32 bit OCI to 64 bit OCI. Have any of you encountered any issues with that ? How much performance improvement can we expect ?
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
Are you making any calls to OCIConnectionPoolDestroy
anywhere in your program?
>
>
> HI.
>
>I am using OCIConnectionPoolCreate to establish
> Connection with database.
>When i run through purifier its showing Leak.
> The traces are as follows
>
>MLK: 128 bytes leaked at 0x1b7c
Yes I am using OCIConnectionPoolDestroy.
-Naren
"Tim Gorman" <[EMAIL PROTECTED]> on 12/30/2002 11:03:41 PM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Narendra Donthineni/HSSBLR)
Are you making any calls to OCIConnect
Hi,
We are seeing an error from a
3rd party etl tool that says:
Cannot find or load Oracle OCI module
This is occurring on a
production box. In comparing the oracle files to our development box, we
are seeing differences (files missing). However, Oracle seems
We're receiving the message :
Get Network Not OK : "ORACLE OCI "
when Business Objects WeBIntelligence tries to connect
to Oracle 816.
The client is running Solaris 8, the message is
happening with Oracle client 817 or with Oracle client
816 64 bit.
I can connect withou
Reply Separator
Author: =?iso-8859-1?q?paquette=20stephane?= <[EMAIL PROTECTED]>
Date: 8/20/2001 1:45 AM
We're receiving the message :
Get Network Not OK : "ORACLE OCI "
when Business Objects WeBIntelligence tries to connect
to Oracle 816.
The client is running
Hi,
One of my developers is trying to use OCI on our recently installed Oracle 9i
instance. The size of the file
libocijdbc9.sl is 142 kb in the 9i version and libocijdbc8.sl was 9 mb in the 8i
version. How can I check to see that this was installed properly?
Bill Carle
AT&T
Data
Dear gurus !
We are facing a severe performance problems here that i have no idea of how
to address.
There is a C++ program , which uses OCI , that does the following.
It initiates a long running SQL select statement, and then fetches the
result set from the DB in buffers of 5000 records.
Now
Hei
..Rayaj.
can I
know what is OCI ? what the function of it ?? As a developer I did't come across
these TERM before .
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Saturday, June 23, 2001 6:34
AMTo: Multiple recipients of list ORACLE-LSu
Implicit Sessions created by JDBC-OCIOur
environment is Aix 4.3.3 and Oracle 8.1.6.2 EE. We do have MTS activated for the
database. Our developers have created a server-side application that
uses JDBC calls to the Oracle OCI interface to
elink
client' and 'relink precomp' from the command line
after the install.
If that does not work, log a tar with Oracle. For
some reason, OCI has gotten pretty flakey.
--- [EMAIL PROTECTED] wrote:
> Hi,
>
> We are seeing an error from a 3
twork Not OK : "ORACLE OCI "
>
> when Business Objects WeBIntelligence tries to
> connect
> to Oracle 816.
>
> The client is running Solaris 8, the message is
> happening with Oracle client 817 or with Oracle
> client
> 816 64 bit.
>
> I can connect
>Dear gurus !
>We are facing a severe performance problems here
>that i have no idea of how
>to address.
>There is a C++ program , which uses OCI , that does
>the following.
>It initiates a long running SQL select statement,
>and then fetches the
>result set from the DB
evere performance problems here that i have no idea
of how
|to address.
|There is a C++ program , which uses OCI , that does the following.
|It initiates a long running SQL select statement, and then fetches
the
|result set from the DB in buffers of 5000 records.
|Now , the problem is t
Do you keep the each batch of 5000 rows ? If yes, are you running out of
memory ?
Anjo.
Andrey Bronfin wrote:
> Dear gurus !
> We are facing a severe performance problems here that i have no idea of how
> to address.
> There is a C++ program , which uses OCI , that does the fol
a severe performance problems here that i have no idea
of how
|to address.
|There is a C++ program , which uses OCI , that does the following.
|It initiates a long running SQL select statement, and then fetches
the
|result set from the DB in buffers of 5000 records.
|Now , the problem is that it tak
evere performance problems here
>that i have no idea of how
>to address.
>There is a C++ program , which uses OCI , that does
>the following.
>It initiates a long running SQL select statement,
>and then fetches the
>result set from the DB in buffers of 5000 records.
&g
Dear all, a few days ago i posted a query regarding the JDBC-THIN driver
using RSA authentication,
a the RSA uses sql*net paramters, and the jdbc-thin would directly connect
to the db using listener,
it was not possible to use RSA.
now we plan to change the setup to use JDBC-OCI driver to connect
Hi,
I'm trying to use an application with oci
built on oracle 7.3.4.3 to connect to a different
database on 9.0.1.0 (32 bits) I'm not able to login.
I can login from the same old environment through
sqlplus. Any idea what might be wrong?
Details: old env hp-ux10.20 oracle 7
Title: RE: OCI files missing from installation? PRODUCTION - RESOLVED
It was the PATH order in the 3rd party'd ini file
ugh!
Thanks for all the replies!
Hannah
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD
Sent: Friday, August 09, 2002 12:33 P
Linear Collider.
We have a multi-threaded OCI direct path program which works quite well under Oracle
9i, but returns a 1403 error under Oracle 8i. The respective versions are 9.0.1.3 and
8.1.6.3. If we can get this program to work, it will be used at various high -energy
physics labs around
o types of database drivers: a type-2 driver, called
the OCI (Oracle Call Interface) driver that utilizes native code, and a type-4
pure Java driver called the thin driver. In single processor environments, the
thin driver works somewhat better than the OCI driver because of the JNI
overhead associated wi
n Sluisdam
Verzonden: Tuesday, September 02,
2003 14:25
Aan: '[EMAIL PROTECTED]'
Onderwerp: connection through oci
between 7.3.4 and 9.0.1 fails
Hi,
I'm trying to use an application with oci
built on oracle 7.3.4.3 to connect to a different
database on 9.0.1.0 (32 bits) I'm
Hi Guys...
I have an application with a remote client... The client is written in
Smalltalk and connects to the database via OCI... It establishes a
connection to the database and keeps it open... If the network link between
the remote client and the server fails, the remote client does not
.
We have a multi-threaded OCI direct path program which works quite well under Oracle
9i, but returns a 1403 error under Oracle 8i. The respective versions are 9.0.1.3 and
8.1.6.3. If we can get this program to work, it will be used at various high -energy
physics labs around the world. One of
Title: Message
I've
gone to using the thin driver exclusively, as (counter-intuitively, I know) it
performs better than the OCI driver. Plus it's easier to
port...
-Original Message-From: Rick Stephenson
[mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 7:
respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Oracle OCI JDBC Driver Not Recommended for Multiprocessor
Machine
Sun's FAQ on java hotspot VM performance
(http://java.sun.com/docs/hotspot/PerformanceF
Title: Message
The
performance of JDBC OCI vs Thin really depends on what you are trying to
do. Thin driver can perform better
than
OCI and in some situations doesn't. Also there are limitations in Thin
driver such as you can't return
a
PL/SQL table using Thin driver, you ca
rch/isbnInquiry.asp?userid=6WIANMIL
0H&isbn=059600088X&itm=2> &isbn=059600088X&itm=2
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, April 03, 2003 10:44 AM
To: Multiple recipients of list ORACLE-L
The perf
Hi,
I wrote an OCI application, that I would like to link on a Ora8i client
(Windows NT). The problem is, that although I don't user any Ora8i specific
functionality, the executable still would not run on a Ora7 client (The
Ora8i OCI.DLL is copyed into the same directory on the Ora7 clie
Tamas,
You've got two choices:
1) install the Oracle8 client wherever the program will be run.
2) rebuild using the Oracle7 OCI library.
Dick Goulet
Reply Separator
Author: Szecsy Tamas <[EMAIL PROTECTED]>
Date: 2/8/2001
Anyone tried this one?
http://soldc.sun.com/articles/oci_cache.html
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Post, Ethan
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list a
Joe Sanderson schrieb:
>
> Hello,
>
> I'm using OCI in my application to connect to the Oracle server (currently
> using orlon call, have not yet moved on to OCILogon). My question is this:
> when the password is sent by the OCI code from the client to the server, is
&
It's crazy: the following happened: The OCI application worked fine on my
maschine. I installed Dev6i. Then the OCI app did not work. I copyed the
OCI.DLL for Ora8i into the same directory as the OCI app and then it worked
again. :-)
This caused me to think, that the OCI app needs the OCI.D
Hi List
Does anyone have an idea about the value in V$session
program column value for Java Thin driver and OCI
driver
Any help would be really appreciated.
TIA
Sami
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http
Hi,
Anyone with examples of using OCI and ref cursors.Can I get some examples for Demo's
of Pl/SQl returning a REf cursor
to an OCI program.
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Basavaraja, Ravindra
INET: [EMAIL PROTECTED]
Fat City Ne
Hi, list friends:
I wonder if we are using XA to connect to rac database, can i still use oci to
write it? I want to try Transparent failover with rac database so that when schedule
down, i need not bring the whole site down, just reboot one db server and some
middleware, so that my
Hello,
I'm using OCI in my application to connect to the Oracle server (currently
using orlon call, have not yet moved on to OCILogon). My question is this:
when the password is sent by the OCI code from the client to the server, is
the password encrypted? I want to find out if my applic
83 matches
Mail list logo