[Orclib-users] WG: Direct Path with NUMBER (10,2)

[Johannsmeier, D. (K-SIPV-4/6) <die...@vo...>]

Hi,

yes, I pass 4 columns instead of 3.

I append the source file to this mail:

#define NUM_COLS      4


dp = OCI_DirPathCreate(tbl,NULL,NUM_COLS,nb_rows);

Thank you and best regards

Dieter Johannsmeier



Von: vincent rogier [mailto:vin...@gm...]
Gesendet: Sonntag, 22. November 2015 20:10
An: Johannsmeier, Dieter (K-SIPV-4/6)
Cc: orc...@li...<mailto:orc...@li...>
Betreff: Re: [Orclib-users] Direct Path with NUMBER (10,2)

Hi,

Did you pass the right number of columns to OCI_DirPathCreate() ?

BTW, OCILIB has moved to GitHub !
Can you use GitHub resources for support (https://github.com/vrogier/ocilib) ?

Best regards,

Vincent

On Fri, Nov 20, 2015 at 11:12 AM, Johannsmeier, Dieter (K-SIPV-4/6) <die...@vo...<mailto:die...@vo...>> wrote:
Hello everybody,

I am new to OCILIB (4.2.0 on Linux)  and I try to extend and run the example ocilib_demo.c
I want to test a NUMBER(10,2) column.
So I extend the test table and add some code to the test program:

        OCI_DirPathSetColumn(dp,1,"VAL_INT", SIZE_COL1,NULL);
        OCI_DirPathSetColumn(dp,2,"VAL_STR", SIZE_COL2,NULL);
        OCI_DirPathSetColumn(dp,3,"VAL_DATE", SIZE_COL3,"YYYYMMDD");
        OCI_DirPathSetColumn(dp,4,"VAL_FLOAT", SIZE_COL4,NUMFORM);      <- new  e.g. #define NUMFORM    "%f"

And:

                        sprintf(val1, "%4d",i + (i*100));
                        sprintf(val2, "value %05d",j + (i*100));
                        sprintf(val3, "%04d%02d%02d",(j%23)+1+2000, (j%11)+1, (j%23)+1);
                        sprintf(val4, "%4.2f",1.01);                                            <-new

                        OCI_DirPathSetEntry(dp,j,1,val1,(unsigned int) strlen(val1),TRUE);
                        OCI_DirPathSetEntry(dp,j,2,val2,(unsigned int) strlen(val2),TRUE);
                        OCI_DirPathSetEntry(dp,j,3,val3,(unsigned int) strlen(val3),TRUE);
                        OCI_DirPathSetEntry(dp,j,4,val4,(unsigned int) strlen(val4),TRUE);      <- new


I try a lot of different things but the column in the database is always NULL. With the help of a debugger I see that
the function OCI_NumberToString doesn’t return something in its output (out_value, out_value_size)

What’s wrong?

Thank you in advance


Dieter Johannsmeier







------------------------------------------------------------------------------

_______________________________________________
Orclib-users mailing list
Orc...@li...<mailto:Orc...@li...>
https://lists.sourceforge.net/lists/listinfo/orclib-users



--
Vincent Rogier