[Devel] Re: [Serdev] Trying Oracle module - debug mode output

[Dmitry Semyonov]

Juan Carlos,

On Tue, 11 Oct 2005, Juan Carlos Castro y Castro wrote:

> The two lines below intrigue me:
> ----------------------------------------------------------------------
> 0(0) db_query
> 0(0) select table_version from version where table_name=:a
> ----------------------------------------------------------------------

The lines are correct.


> 0(0) select table_version from version where table_name=:a
> 0(0) oci_prepare
> 0(0) bind_values: DB_STR - subscriber
                             ~~~~~~~~~~
Here is the value of ':a'.


> 0(0) oci_execute
> 0(0) map_int_param_type_and_size_to_ext: Oracle type SQLT_NUM
> 0(0) map_int_param_type_and_size_to_ext: SQLT_NUM precision 38, scale 0
> 0(0) map_int_param_type_and_size_to_ext: External type SQLT_FLT, size 8
> 0(0) ORA-24334. Not an error probably.
> 0(0) define_params: ora_params_num = 1
> 0(0) convert_row: params_num = 1, _r = 0xf6ff330c
> 0(0) SQLT_FLT: 5.000000e+00
       ~~~~~~~~~~~~~~~~~~~~~~

You should see something like
SQLT_INT: <number>
here.


 P.S.
I sent my version table schema to the list some time ago.

-- 
...Bye..Dmitry.