C++ Call Interface :: Forward Compatibility Of Occi Application?
Apr 1, 2013
We have a occi application which is linked dynamically to occi lib on Solaris. Now during build we linked it with occi of Oracle 10.2.0.4 client but we want the same build to be able to run under Oracle 10G client as well as Oracle 11G client. But it seems that occi is not forward not backward compatible as name of dynamic occi lib has a version in it.
e.g
md1sisun26:/tools/oracle/10.2.0.4/lib->dump -Lv libocci.so
libocci.so:
**** DYNAMIC SECTION INFORMATION ****
.dynamic:
[INDEX] Tag Value
[1] INIT 0xc6110
[2] FINI 0xc62b8
[code]...
As you can see when we run our occi application under Oracle 11G client it fails as there is no libocci.so.10.1 .
View 0 Replies
ADVERTISEMENT
Aug 21, 2012
I wrote a simple OCCI program and ran valgrind with it. I got some memory leak in the program. I tried to search around but couldn't get any answers. I have tried to compile the program using gcc version 4.5, and icpc version 12.0.4 and they both gave the same errors. The OS I am using is RedHat Linux 6.1.
#include "occi.h"
#include <iostream>
#include <string>
int main() {
oracle::occi::Environment *theOCCIEnvPtr = NULL;
[Code] .......
and one of the leaks is :
==9744== 32 bytes in 1 blocks are definitely lost in loss record 61 of 224
==9744== at 0x4A07279: malloc (vg_replace_malloc.c:263)
==9744== by 0x62D9147: slzsetevar (in /apps/oracle_client/libclntsh.so.11.1)...
View 5 Replies
View Related
Jun 28, 2012
I install Oracle instant client 11g in my Windows 7(32bit), and use MSVC6++ to test program occidml.cpp, compile is no problem, but when I run it, it crash on create Connection. I have tried to link with different version of OCCI library ( v8,v9), but all crash on create Connection.
View 0 Replies
View Related
Jul 11, 2012
I'm trying to compile an hello world example on my computer. I've read the documentation for requirements occi on the site
[URL]....
It says that the g++ compiler 3.4.6 or later is supported. I have:
Ubuntu 12.04
gcc 4.6.3
oracle instant client 11.2
g++ main.cpp -c -I/home/tim/skrivbord/bin/oracle/instantclient_11_2/include/ -D_REENTRANT -g -Wall
g++ -o pippo -L/home/tim/skrivbord/bin/oracle/instantclient_11_2/ -locci -lclntsh -lociei -lnnz11 main.o
main.o: In function `main':
/home/tim/skrivbord/dev/cpp/main.cpp:21: undefined reference to
[code]....
View 1 Replies
View Related
Jun 20, 2012
I am completely new to anything with Oracle or OCI,
Also, basic information:
Language: C
Oracle DB version: 11g
Trying to use OCI
I am trying to write a client that connects to an Oracle database and gets some information (obviously). On the OCILogon() step, I need the username, password, and db address. However, someone said there will be a tnsnames.ora file, and that should be enough.I've searched online and I have not been able to find anything that relates OCILogon() to tnsnames.ora, so here are my questions:
1) Can OCILogon() use tnsnames.ora at all?
2) Is there any other function that I should use instead of OCILogon() that would work with the tnsnames.ora
View 2 Replies
View Related
Nov 20, 2012
I am attempting to port some Pro*C code from Tru64 to AIX 6.1.I have compiled the PRO*C into an executable which is then called as follows:
host$ CJSPC004 /@WHDA 19/11/2012
Starting module : CJSPC004
Connected to the database
Running database procedure cjspk003.p_create_job_schedule
Module CJSPC004 completed successfully
However, when querying $? to get the status of the last command I get a non-zero code even though everything has worked.
host$ echo $?
39
On Tru64 this works fine with the echo $? returning a zero as expected:
host$ echo $?
0
The PRO*C was compiled using gcc
View 1 Replies
View Related
Aug 17, 2012
In the below code, the application is crashing @ free(svcname). should we delete the out variable or not?
{
char* svcname;
if (OCIAttrGet(eventhp, (ub4) OCI_HTYPE_EVENT, (dvoid *) &svcname, (ub4 *) &sizep, OCI_ATTR_SERVICENAME, dm_infop->errhp) != OCI_SUCCESS) {
pinlog(PIN_FILE_SOURCE_ID, __LINE__, LOG_FLAG_ERROR, " Unable to get service name.
");
return;
}
free(svcname);
}
View 1 Replies
View Related
May 29, 2013
Our API supports Oracle 11.2g but uses OCI v8 yet.This means I cant activate client caching as a new feature ? We should update to OCIv11 ?
View 5 Replies
View Related
Nov 30, 2012
Actually i am not using OCI directly. I have a Delphi application in which I would need to clone an open db connection. Not only username, password, and target database (this is easy and i already do that).
What I would need is also inherit context variables and global temporary tables content status at the moment in which the cloning operation takes place. It seems a very difficult, if not impossible, thing to achieve.
View 1 Replies
View Related
Jul 11, 2013
I am using OCI and instant_client (11.2.0.3.0) in my C++ program (on Windows 7) to connect remotely to 11G database. While doing a connection using server name as well as servername:port/service_name as connection strings, I am getting error of ORA-12504 TNS:listener was not given the SERVICE_NAME in CONNECT_DATA. According to instant client FAQ & white paper at [URL]..., no tnsnames.ora is required for instant client. Then why could I be getting this error? I ensured that only the instant client directory is in Path environment variable. There was a ODBC driver installed on this same host.
View 3 Replies
View Related
Aug 6, 2012
We have code that occasionally errors with ORA-12151, with tracing indicating some funk surrounding OCI calls to OCIPing(), OCIBreak(), and OCIReset(). What the code is trying to do here is release a connection from a pool (our implementation, not OCIPool) and before releasing it trying to make sure nothing is actively running on the connection etc. The environment is created in THREADED mode (ie not non-blocking).
Reading the documentation its not really clear to me if OCIBreak() and OCIReset() are really intended to be called while in THREADED mode.
Is it a bad idea to call break/reset as part of a general connection-reset routine?
The basic control flow (minus error handling etc) is:
<pre>
reset() {
int rc = OCIBreak(connection_, err_);
rc = OCIReset(connection_, err_);
if (OCIPing(connection_, err_, OCI_DEFAULT) != OCI_SUCCESS) {
return errors;
}
return 0;
}
</pre>
View 0 Replies
View Related
Nov 27, 2012
I am trying to fetch the data from system table "FLOWS_020100.WWV_FLOW_ACTIVITY_LOG1$" in Oracle Express edition 10.2.0.3 database, using the OCI library on Windows with C++
This table has a TIMESTAMP column of date type.
I've the following query as below:
select TIME_STAMP from FLOWS_020100.WWV_FLOW_ACTIVITY_LOG1$ where TIME_STAMP > to_date('31/OCT/12 23:59:59', 'DD-MON-YY HH24:MI:SS') order by TIME_STAMP asc;
For this, first I am preparing the query as below:
select TIME_STAMP from FLOWS_020100.WWV_FLOW_ACTIVITY_LOG1$ where TIME_STAMP > :PKVAL order by TIME_STAMP asc;
Before calling OCIExecute(), I am setting the PKVAL buffer to following value:
"to_date('31/OCT/12 23:59:59', 'DD-MON-YY HH24:MI:SS') "
& calling the OCIBindByName function with data type as SQLT_DATE.
But when the OCIExecute is called, my program crashes with access violation
what is the correct way to pass the date value in query to OCI? How do we bind the date values?
View 1 Replies
View Related
Dec 20, 2012
I want to monitor the stream activity with strmmon tool. How to compile the strmmon.mk? I was seeing with visual studio command prompt but it does not work properly.
Oracle Version: 10.2.0.4
Server: Win 2008 R2
View 0 Replies
View Related
Sep 6, 2012
There are only OCI headers in 9.2.0/rdbms/demo directory in our installation of Oracle 9.2:
9.2.0/rdbms/demo/ocixad.h
9.2.0/rdbms/demo/oci.h
9.2.0/rdbms/demo/oci1.h
...
In Oracle 10.2 installation there are OCI headers in rdbms/public directory:
10.2.0/rdbms/public/ocidem.h
10.2.0/rdbms/public/ocidfn.h
10.2.0/rdbms/public/ocikpr.h
10.2.0/rdbms/public/oci.h
10.2.0/rdbms/public/oci1.h
...
What should be installed additionally to have OCI headers in rdbms/public in Oracle 9.2.0?
View 0 Replies
View Related
Jun 14, 2012
I am having an issue to connect my C++ application to my Oracle DB. When my code calls
oracle::occi::Environment::createEnvironment(),
I get an error "ORA-01804: failure to initialize timezone information".
The application works on other people's Windows machine with their Oracle DB. But it doesn't work from my machine connecting to their Oracle instance. So I guess the issue does not come from my instance but rather from my Oracle dlls maybe?
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0
View 0 Replies
View Related
Apr 22, 2013
I am in the process of converting my skill in oracle and this time PRO*C from Windows to Linux. I have oracle 11g R2 installed on a UBUNTU (12.04) server and have installed the instant client as described in
[URL]
This has a query which will run in SQLPLUS but fails with PRO*C
:~/Projects/proc/proctest1$ proc INAME=proctest.pc SQLCHECK=NONE ONAME=proctest.c LNAME=proctest.lis LTYPE=long
Pro*C/C++: Release 11.2.0.3.0 - Production on Mon Apr 22 21:00:18 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
System default option values taken from: /home/neill.rutherford/instantclient_11_2/precomp/admin/pcscfg.cfg
PCC-W-02109, SQLCHECK=NONE is no longer supported.. using SYNTAX
[code]....
View 0 Replies
View Related
Oct 16, 2013
I work with oracle 10g, on windows 7. sometime when i try to start my sqlplus in prompt command this message display.
C:UsersSony>sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
But the solution people have proposed into the forum are:
1 - check the environment variable Oracle_home and modify if it ending by ""
2 - or try tho run my promt command as Administrator.
I try the both, but only the second works. while now i don't understand why it works when i start the promt command as Administrator and why it no works when i don't run it like administrator. Another thing is i am the only user of my computer, i have only one session (administor session).
View 4 Replies
View Related
Nov 19, 2012
In my application, when I passed a Type Array as parameter to the stored procedure and when the Type Array is large enough(normally 3000 type objects, each objects has about 15 attributes), the OCIObjectSetAttr performance deteriorates large enough from below 1 millisecond to 1~3 miliseconds.
I am using OCI 11gR2,
View 0 Replies
View Related
Mar 10, 2010
I am facing the problem in windows 7. I have oracle client 10g installed. When i run sqlplus from comand prompt it gives the error as:
C:Userssrirams>sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
When I select the executable 'sql+' and run as administrator it works fine.
View 6 Replies
View Related
Sep 6, 2012
when i try to connect with sqlplus or toad then i get an error
Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:Users>sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
C:Users>
and i want to tell what i do before it-my all files were be converted in .FLT then i shorted out this problem after that when i tried to connect with sqlplus or toad then i get above error.and i have restarted my system but throwing same error.
i am using oracle 11.2.0.1 on windows 7
View 5 Replies
View Related
Mar 20, 2013
Environment:_
APEX Version 4.2.0.00.27
Theme 25
I have a number of pages that use the page template "*One Level Tabs - Content Frame*".End users that use Internet Explorer (versions 8 and 9), when they first visit the application their browser displays it in Compatibility View.They cannot see the side bar on the right-hand side, meaning that often they cannot see a lot of necessary buttons and info!
Their page displays as below: URL....
I am not sure it is possible, nor good practice, to force the app to display in non-compatibility mode.Is there a way to enhance their experience? Or another workaround?
At the moment I am waiting until they log an issue and then informing them to turn compatibility view off, or to use Chrome or Firefox. I'd like to make it better from my end!
View 6 Replies
View Related
Nov 12, 2012
APEX 4.2 Theme 25 Oracle DB 11gr2 - I need to conditionally display Html5/Flash chart regions depending on browser compatibility, how to achieve this.
View 8 Replies
View Related
Feb 1, 2010
I'm using an existing stored procedure in my C code. The stored procedure in question has been compiled and is proven to work without any errors. However, when I use the same in my C code, its failing with the above error.
The Store procedure definition looks like :
CREATE OR REPLACE FUNCTION SP(
srq_id integer ,
unid IN SPkg.arr_parmid,
parm_typ IN SPkg.arr_parm_typ,
[code].....
Type definitions
TYPE arr_parm_typ IS TABLE OF char INDEX BY BINARY_INTEGER;
TYPE arr_parmid IS TABLE OF tbl_parm.UNID%TYPE INDEX BY BINARY_INTEGER;
TYPE arr_parm_lbl IS TABLE OF tbl_parm.PARM_LBL%TYPE INDEX BY BINARY_INTEGER;
TYPE arr_parm_vlu IS TABLE OF tbl_parm.PARM_VLU%TYPE INDEX BY BINARY_INTEGER;
TYPE arr_vlu_hint IS TABLE OF tbl_parm.VLU_HINT%TYPE INDEX BY BINARY_INTEGER;
My C code looks like :
typedef struct param
{
char lbl[30][81];
char vlu[30][256];
char typ[30];
ub8 seq_no[30];
[code].....
The way I invoke the stored procedure:
char command[250] = "begin
:retval := SSP_srq_parm_all(:srq_id,:unid,:parm_typ,:parm_lbl,:parm_vlu,:commit_flag,:vlu_hint,:create_flag);
end;";
OCIStmtPrepare2((OCISvcCtx *)svchp, (OCIStmt **)&(stmthp),
(OCIError *)errhp, (OraText *)command,
[code].....
OCIStmtExecute() fails with the above error.
View 3 Replies
View Related
Jan 28, 2011
I have a Cobol program that call C program above
#include stdlib
EXEC SQL INCLUDE SQLCA;
EXEC SQL BEGIN DECLARE SECTION;
char *uid = "puntos/puntos@cmrdesar";
[code]....
Are something wrong in C programm ? Pro*C code from vouters.dyndns.org/tima/OpenVMS-Cobol-C-Cobol_ passing_ variable_ number_ of_ arguments_to_C.html
View 1 Replies
View Related
Jan 24, 2009
My 10g pro*c application works perfectly, recently I upgraded it to 11g, but it keep crashing, why?
View 10 Replies
View Related
Sep 28, 2010
Do Oracle Forms 9i/10g work with Enterprise DB?
View 3 Replies
View Related
Aug 30, 2012
Is Oracle Database 11g Release 2 (11.2.0.2.0) compatible on Red hat enterprise linux 5 update 7 ( RHEL 5.7 ) ?
View 5 Replies
View Related
Mar 17, 2011
We are planning on upgrading from XP to Windows 2007. We are running Forms/Reports 6i (client server). Is 6i compatible with Windows 2007?
View 3 Replies
View Related
Aug 31, 2012
If i have Oracle Wallet installed for a Oracle 10.2 Client, i am able to connect to the database. But , while generations a report , when my oracle report server tries to connect to the DB using Oracle Wallet
(i.e. sqlplus /@<dbname> ) , I am not able to establish a connection.
Is it a compatibility issue ?
Following is the parameter i am passing.
$ORACLE_HOME/bin/rwclient.sh server="$REPORT_SERVER" REPORT="$RDF_FILE" DESTYPE=FILE DESNAME="$PDF_FILE" DESFORMAT=PDF BATCH=YES USERID= /@"$ORACLE_SID"
View 0 Replies
View Related
Oct 1, 2012
I called an application from Oracle forms using: Client_Host('cmd /c START "" "\localPathmyApplication.exe"'); This works fine on local as well as server.
But when I use the same command to call the application directly from the MENU ITEM, it gives error alert: "WebUtil Error: oracle.forms.webutil.host.Host bean not found. WEBUTIL_HOST.Execute will not work."
I even tried using DDE.App_Begin(). This gives error: ORA-106561. How can I call any application (.exe) directly from the menu item on the server?
View 3 Replies
View Related