Re: [Orclib-users] Simple insert with in variables to procedure

[vincent r. <vin...@gm...>]

I'm currently finishing creating release packages for v4.0.1.
They will be online wihtin the next hour.

You cannot send a C++ class to an oracle procedure.

Regards,

Vincent

On Tue, Jan 13, 2015 at 10:34 PM, Miguel Vaz <pag...@gm...> wrote:

> Hi Vincent,
>
> Thats perfectly ok. Just glad you know what the problem is. I did spend
> the whole afternoon cursing over my code and lack of skills, hehe. :-)
>
> On a different note, how can i send a simple class over to an oracle
> procedure?
>
> Something like:
>
> class person{
>    string nome;
>    int id;
> }
>
> on the oracle side somethign like:
>
> create ...
> procedure_name(indata IN cursor){
>
>
> }
>
> Any pointer on this is great help.
>
> Again, no worries about the bug. :-)
>
> best regards,
> MV
>
>
>
>
>
>
>
>
>
>
>
>
> On Tue, Jan 13, 2015 at 6:40 PM, vincent rogier <vin...@gm...>
> wrote:
>
>> Hi Miguel,
>>
>> I apologize as there is an issue with binding string in the released
>> header files.
>>
>> I'm going to release an version 4.0.1 with some fixes for both C and C++
>> APIs this week.
>>
>> Regarding your issue, while waiting for the new packages, you can fix it
>> quickly by making the following simple modification :
>>
>> * in the file ocilib_impl.hpp, line 3860  (BindAdaptor template class
>> constructor)
>> * replace _size by size
>>
>> and it should work again :)
>>
>> Sorry for the inconvenience !
>>
>> Regards,
>>
>> Vincent
>>
>>
>> On Tue, Jan 13, 2015 at 6:15 PM, Miguel Vaz <pag...@gm...> wrote:
>>
>>> Hi,
>>> I cant a simple insert to work using a procedure and ocilib.
>>>
>>> The procedure:
>>>
>>> CREATE OR REPLACE
>>> PROCEDURE criasistema(idout OUT NUMBER, nm IN VARCHAR2) AS
>>> BEGIN
>>> insert into sistemas(NOME) values(nm) returning id_sistema into idout;
>>>
>>> END;
>>>
>>>
>>> Heres the c++ code:
>>>
>>> Environment::Initialize(Environment::Default | Environment::Threaded);
>>> string sql = "declare ids NUMBER begin criasistema(:ids,:nm); end;";
>>>
>>> try{
>>> con.Open(connectString, user, passw);
>>> Statement st(con);
>>> Statement st2(con);
>>> st.Prepare(sql);
>>> st.Bind(":ids", st2, BindInfo::Out);
>>> st.Bind(":nm", nome, 255, BindInfo::In);
>>> st.Execute();
>>>
>>> con.Commit();
>>> con.Close();
>>>
>>> }
>>> catch (Exception &ex){
>>> cout << ex.what() << endl;
>>> }
>>>
>>> Environment::Cleanup();
>>>
>>> It compiles but breaks at st.Bind(":nm", nome, 255, BindInfo::In);
>>> What am i doing wrong?
>>>
>>> I assumed it would be simply a matter of binding in and out variables
>>> and it shuld work, but not so easy.. :-P
>>>
>>> I am really not at easy with the binds. Next step will be to send a full
>>> object (int,string,...) array, but if i cant solve this simple string
>>> issue, i am not going anywahere.
>>>
>>> Thanks.
>>> MV
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
>>> GigeNET is offering a free month of service with a new server in Ashburn.
>>> Choose from 2 high performing configs, both with 100TB of bandwidth.
>>> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
>>> http://p.sf.net/sfu/gigenet
>>> _______________________________________________
>>> Orclib-users mailing list
>>> Orc...@li...
>>> https://lists.sourceforge.net/lists/listinfo/orclib-users
>>>
>>>
>>
>>
>> --
>> Vincent Rogier
>>
>
>


-- 
Vincent Rogier