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

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

Hi,

I have made a test with a format string “9999999.99“ and test it with a sql statement which contains a to_number call.
But if I insert this format into my test program the results are the same. (NULL values)

Thank you

Dieter

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


Hi,

Sorry for the late response.

There is an issue with the numeric format you passed to oci_dirpathsetcolumn().
It must be an oracle format (see reference of the sql to_number() function).

More generally, always use an error handler that will always be triggered in case of oracle or internal error.

Best regards,

Vincent

Le 20 nov. 2015 11:12, "Johannsmeier, Dieter (K-SIPV-4/6)" <die...@vo...<mailto:die...@vo...>> a écrit :
>
> 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
>