Category : oracle

Currently I’m using OCIEnvCreate() to create an OCI session handle to communicate with Oracle databases. I’d like to explicitly use UTF8 rather than relying on whatever client locale has been set, and I gather that I need to use OCIEnvNlsCreate() to do this. But there’s something I don’t understand. Here’s the signature for OCIEnvNlsCreate(): sword ..

Read more

I’ve installed Oracle Instance inside of docker container and I put sql script whitch runs when a container starts: Dockerfile: FROM… … CMD powershell echo @C:scriptsentrypoint.sql | sqlplus -S sys/password as sysdba entrypoint.sql: set serveroutput on format wrapped; declare userexist integer; db_schema_version varchar2(20); begin select count(*) into userexist from dba_users where username=’DEV’; if (userexist = ..

Read more

I am trying to link a database with my c++ here using occi.h. But I am getting linker error LNK1120 and LNK2019, here is my code: #include <iostream> #include <string> #include <occi.h> #include <cctype> using oracle::occi::Environment; using oracle::occi::Connection; using namespace oracle::occi; using namespace std; struct Cart { int product_id; double price; int quantity; }; int ..

Read more