<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en" xmlns="http://www.w3.org/2005/Atom"><title>Recent changes to support-requests</title><link href="https://sourceforge.net/p/orclib/support-requests/" rel="alternate"/><link href="https://sourceforge.net/p/orclib/support-requests/feed.atom" rel="self"/><id>https://sourceforge.net/p/orclib/support-requests/</id><updated>2018-01-22T16:22:02.090000Z</updated><subtitle>Recent changes to support-requests</subtitle><entry><title>libclntsh.so.12.1: undefined reference</title><link href="https://sourceforge.net/p/orclib/support-requests/25/" rel="alternate"/><published>2018-01-22T16:22:02.090000Z</published><updated>2018-01-22T16:22:02.090000Z</updated><author><name>Anonymous</name><uri>https://sourceforge.net/u/userid-None/</uri></author><id>https://sourceforge.net06ec64ef38a467750f1f9f77e68dc4d2ed05a326</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi all,&lt;/p&gt;
&lt;p&gt;thank you guys for your amazing work and support.&lt;/p&gt;
&lt;p&gt;We have upgraded Oracle to 12.1 and OCILIB 4.4.1 but when we try to compile the sample code we have these errors. It seems to be a mismatch in the versions but which version of OCILIB should we use ?&lt;/p&gt;
&lt;p&gt;Here is the error message:&lt;/p&gt;
&lt;p&gt;user@hxxx1 &amp;gt; gcc -I$HELIOS_EPM/ocilib/include -L$HELIOS_EPM/ocilib/lib -locilib ocilib_demo.c&lt;br/&gt;
/helios/poc/esb1/ora/u01/oracle/v121/client1_x64/lib/libclntsh.so.12.1: undefined reference to &lt;code&gt;ons_subscriber_create_wtimeout_ctx'
/helios/poc/esb1/ora/u01/oracle/v121/client1_x64/lib/libclntsh.so.12.1: undefined reference to&lt;/code&gt;ons_init_wconfig_ctx'&lt;br/&gt;
/helios/poc/esb1/ora/u01/oracle/v121/client1_x64/lib/libclntsh.so.12.1: undefined reference to &lt;code&gt;ons_shutdown_wtimeout_ctx'
/helios/poc/esb1/ora/u01/oracle/v121/client1_x64/lib/libclntsh.so.12.1: undefined reference to&lt;/code&gt;ons_error_set'&lt;br/&gt;
/helios/poc/esb1/ora/u01/oracle/v121/client1_x64/lib/libclntsh.so.12.1: undefined reference to `ons_thread_stacksize'&lt;br/&gt;
collect2: ld returned 1 exit status&lt;/p&gt;
&lt;p&gt;Thank you very much for your reply&lt;br/&gt;
A&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>#23 ORDImage</title><link href="https://sourceforge.net/p/orclib/support-requests/23/?limit=25#41d2" rel="alternate"/><published>2017-10-15T17:04:36.947000Z</published><updated>2017-10-15T17:04:36.947000Z</updated><author><name>Vincent Rogier</name><uri>https://sourceforge.net/u/vincedelparis/</uri></author><id>https://sourceforge.net05a654f59f1e8c52029096e6ae7cf217937dc315</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;OCILIB is using Github for source control, bug tracker and support request : &lt;a href="https://github.com/vrogier/ocilib" rel="nofollow"&gt;https://github.com/vrogier/ocilib&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;Of course it is possible, using OCILIB support for UDTs (OCI_Object).&lt;/p&gt;
&lt;p&gt;Best regards,&lt;/p&gt;
&lt;p&gt;Vincent&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>#24 Memory leak in OCI_ConnectionCreateInternal</title><link href="https://sourceforge.net/p/orclib/support-requests/24/?limit=25#986b" rel="alternate"/><published>2017-10-15T17:02:56.124000Z</published><updated>2017-10-15T17:02:56.124000Z</updated><author><name>Vincent Rogier</name><uri>https://sourceforge.net/u/vincedelparis/</uri></author><id>https://sourceforge.netaaa40c469bbb81df95591c5227cb219da5033178</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;OCILIB is using Github for source control, bug tracker and support request : &lt;a href="https://github.com/vrogier/ocilib" rel="nofollow"&gt;https://github.com/vrogier/ocilib&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;I do not see the problem from your image.&lt;/p&gt;
&lt;p&gt;In any case, connection is freed if one of the 2 calls fail.&lt;br/&gt;
I think it is a false positive finding from Memory Validator.&lt;/p&gt;
&lt;p&gt;Best regards,&lt;/p&gt;
&lt;p&gt;Vincent&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Memory leak in OCI_ConnectionCreateInternal</title><link href="https://sourceforge.net/p/orclib/support-requests/24/" rel="alternate"/><published>2017-10-14T11:18:21.230000Z</published><updated>2017-10-14T11:18:21.230000Z</updated><author><name>Josemi Antelo</name><uri>https://sourceforge.net/u/joxemi/</uri></author><id>https://sourceforge.nete00cda4be25039fdaa40fb73e6563ded32ac2fa5</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Memory Validator program show me an psoible memory leak in that routine. See the image attached&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>ORDImage</title><link href="https://sourceforge.net/p/orclib/support-requests/23/" rel="alternate"/><published>2017-08-18T15:44:26.943000Z</published><updated>2017-08-18T15:44:26.943000Z</updated><author><name>Anonymous</name><uri>https://sourceforge.net/u/userid-None/</uri></author><id>https://sourceforge.net3256dba761a5977454cc8952ac5acd17c5af6535</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi&lt;br/&gt;
There is a table that a column of it is  ORDImage (inside of ORDImage  it is jpg file as a blob) . Is it possible to read the Image Data (jpg-blob)  by OCILib ?&lt;br/&gt;
Regards&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>#22 Issue with binding stored proc Number c++</title><link href="https://sourceforge.net/p/orclib/support-requests/22/?limit=25#a6e9" rel="alternate"/><published>2016-12-08T00:55:00.419000Z</published><updated>2016-12-08T00:55:00.419000Z</updated><author><name>Vincent Rogier</name><uri>https://sourceforge.net/u/vincedelparis/</uri></author><id>https://sourceforge.netd0f9b9df60af23d8346fcecdf2ee18e34230c6dc</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;All good, I worked it out, I was binding it in another function but hadn't referenced the original variable&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Issue with binding stored proc Number c++</title><link href="https://sourceforge.net/p/orclib/support-requests/22/" rel="alternate"/><published>2016-12-07T05:07:52.007000Z</published><updated>2016-12-07T05:07:52.007000Z</updated><author><name>Anonymous</name><uri>https://sourceforge.net/u/userid-None/</uri></author><id>https://sourceforge.netb7421c6eb297cda9c8ece28c68cecafc79524a76</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi I'm fairly new ocilib and having a couple of issues with binding in a stored proc, hopefully should be simple and you can help&lt;br/&gt;
I am able to call the stored proc successfully if I hard code the parameters, they are all in bound:&lt;br/&gt;
Statement st(m_Connection);&lt;br/&gt;
oSql = "BEGIN NETWORK.WP_SITE_ID_RESERVATION.ADDBULK('WP16_12_2_4', 2, 'JG026');END; ";&lt;br/&gt;
st.Prepare(oSql);&lt;/p&gt;
&lt;p&gt;the issue is if I try to bind the number '2' this fails to reach the stored proc. The stored proc gets a value of '0'. The parameter in the stored proc is number.&lt;/p&gt;
&lt;p&gt;If I use the below&lt;/p&gt;
&lt;p&gt;Statement st(m_Connection);&lt;br/&gt;
oSql = "Begin NETWORK.WP_SITE_ID_RESERVATION.ADDBULK (:p01,:p02,:p03); End;";&lt;br/&gt;
st.Prepare(oSql);&lt;/p&gt;
&lt;p&gt;int num = 2l;&lt;br/&gt;
st.Bind(":p02", num , BindInfo::In);&lt;/p&gt;
&lt;p&gt;The stored proc gets a value of 0&lt;/p&gt;
&lt;p&gt;the string binds works fine&lt;/p&gt;
&lt;p&gt;Hopefully there is something simple I am missing, hope you can help.&lt;/p&gt;
&lt;p&gt;Cheers&lt;/p&gt;
&lt;p&gt;John&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>#21 UTF16 in C++</title><link href="https://sourceforge.net/p/orclib/support-requests/21/?limit=25#9e19" rel="alternate"/><published>2016-05-19T09:24:55.290000Z</published><updated>2016-05-19T09:24:55.290000Z</updated><author><name>Vincent Rogier</name><uri>https://sourceforge.net/u/vincedelparis/</uri></author><id>https://sourceforge.net48fb644c3853ff9402258624f3ae5b8d6aad1e7c</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Sry i entered the wron title. It should not be "UTF16 in C++". &lt;br/&gt;
This has probably nothing to to with UTF16 encoding :)&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>UTF16 in C++</title><link href="https://sourceforge.net/p/orclib/support-requests/21/" rel="alternate"/><published>2016-05-19T09:22:57.060000Z</published><updated>2016-05-19T09:22:57.060000Z</updated><author><name>Anonymous</name><uri>https://sourceforge.net/u/userid-None/</uri></author><id>https://sourceforge.netc89b70f4c67698e1802f70ac0a2dc182c8e985e7</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;i need to write Korean Characters (example: 향찰/鄕札) into an Oracle database via a C++ Middleware that is using the OCILIB.&lt;br/&gt;
It is already possible to write and save these characters with a C# Service that uses the Oracle-Libs, which means that the Database should be configured correctly.&lt;/p&gt;
&lt;p&gt;The C++ Middleware runs on Linux and we set the NLS_LANG to GERMAN_GERMANY.AL32UTF8.&lt;br/&gt;
I am able to see the cahracters in the console/log but if i try to write them into the database via an Object that accepts the values as parameters they turn to '¿¿¿¿'.&lt;/p&gt;
&lt;p&gt;The C#-Service uses the same Objects to write the data.&lt;/p&gt;
&lt;p&gt;The values are bound as strings (std::string) in the C++ Middleware.&lt;br/&gt;
Do i need to adjust anything else than the NLS_LANG to make this work?&lt;br/&gt;
For example the Binding?&lt;/p&gt;
&lt;p&gt;I could not find anything that matters in the OCILIB C Documentation and there aren't any examples for C++ for cases with special characters.&lt;/p&gt;
&lt;p&gt;We tried for days but the characters ultimatively end up as '¿¿¿¿' in the databse tables if we write them via the C++ Middleware.&lt;/p&gt;
&lt;p&gt;Thanks for your help!&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>OCI_BindArrayOfNumbers</title><link href="https://sourceforge.net/p/orclib/support-requests/20/" rel="alternate"/><published>2014-09-30T21:30:18.918000Z</published><updated>2014-09-30T21:30:18.918000Z</updated><author><name>Tamás Gulácsi</name><uri>https://sourceforge.net/u/tgulacsi/</uri></author><id>https://sourceforge.net06c3fae7c7c88eef31501ac53acb1cb3050548ec</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;Hi,&lt;/p&gt;
&lt;p&gt;Please help me bind array of OCINumbers! The minimal example I have SIGSEGV's at OCI_Execute.&lt;/p&gt;
&lt;p&gt;gthomas@waterhouse:~/src/github.com/tgulacsi/gocilib/exp/num$ gdb ./num_array&lt;br /&gt;
GNU gdb (Debian 7.7.1+dfsg-3) 7.7.1&lt;br /&gt;
Reading symbols from ./num_array...(no debugging symbols found)...done.&lt;br /&gt;
(gdb) run&lt;br /&gt;
Starting program: /home/gthomas/src/github.com/tgulacsi/gocilib/exp/num/num_array&lt;br /&gt;
&lt;span&gt;[Thread debugging using libthread_db enabled]&lt;/span&gt;&lt;br /&gt;
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".&lt;br /&gt;
cn=0x6aacb0&lt;br /&gt;
st=0x6aacb0&lt;br /&gt;
errhp=0x6aea40&lt;br /&gt;
in_nums&lt;span&gt;[0]&lt;/span&gt;=1&lt;br /&gt;
in_nums&lt;span&gt;[1]&lt;/span&gt;=2&lt;br /&gt;
in_nums&lt;span&gt;[2]&lt;/span&gt;=3&lt;br /&gt;
in_nums=Á@&lt;br /&gt;
setSize&lt;br /&gt;
bindArray&lt;br /&gt;
bindString&lt;/p&gt;
&lt;p&gt;Program received signal SIGSEGV, Segmentation fault.&lt;br /&gt;
0x00007ffff6fc6593 in ttcs2c () from /usr/lib/oracle/12.1/client64/lib/libclntsh.so.12.1&lt;/p&gt;
&lt;p&gt;Code is attached.&lt;br /&gt;
I've compiled the code with&lt;/p&gt;
&lt;p&gt;gcc -I/usr/include/oracle/12.1/client64 -L/usr/lib/oracle/12.1/client64/lib \
        -locilib -lclntsh \
        num_array.c -o num_array&lt;/p&gt;&lt;/div&gt;</summary></entry></feed>