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

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

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...> 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...
> https://lists.sourceforge.net/lists/listinfo/orclib-users
>