Skip to Content.
Sympa Menu

freetds - Re: [freetds] Using DBRPCPARAM

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Using DBRPCPARAM
  • Date: Mon, 19 Jun 2006 17:01:38 +0200

>
> Hello, iam using dblib to work with stored procedures and i
> get seg fault while running dbrpcparam-dbsqlsend-dbsqlok and
> so. Logs show that info :
>

Hi,
sorry for late reply. It seems you are callng a
"Telviso_ValidaSaldoTarjetaAni" procedure that require 6 parameters.

> 17:46:40.178147 dbsqlok() marker is e3
> 17:46:40.178158 processing result tokens. marker is e3(ENVCHANGE)
> 17:46:40.178168 tds_process_default_tokens() marker is e3(ENVCHANGE)
> 17:46:40.178177 tds_get_string: reading 20 from wire to give
> 10 to client.
> 17:46:40.178190 tds_get_string: reading 20 from wire to give
> 10 to client.
> 17:46:40.178202 processing result tokens. marker is ab(INFO)
> 17:46:40.178211 tds_process_default_tokens() marker is ab(INFO)
> 17:46:40.178222 tds_get_string: reading 82 from wire to give
> 41 to client.
> 17:46:40.178233 tds_get_string: reading 12 from wire to give
> 6 to client.
> 17:46:40.178245 processing result tokens. marker is e3(ENVCHANGE)
> 17:46:40.178263 tds_process_default_tokens() marker is e3(ENVCHANGE)
> 17:46:40.178277 processing result tokens. marker is fd(DONE)
> 17:46:40.178286 tds_process_end: more_results = 0
> was_cancelled = 0
> error = 0
> done_count_valid = 0
> 17:46:40.178295 tds_process_end() state set to TDS_IDLE
> 17:46:40.178304 dbsqlok() end status was success
> 17:46:40.178315 dbresults()
> 17:46:40.178327 tds_process_row_tokens() state is COMPLETED
> 17:46:40.178399 dbrpcinit() added rpcname
> "Telviso_ValidaSaldoTarjetaAni"
> 17:46:40.178450 dbrpcparam() added parameter "@devuelve"
> 17:46:40.178461 dbrpcparam() added parameter "@tarjeta"
> 17:46:40.178471 dbrpcparam() added parameter "@ani"
> 17:46:40.178481 dbrpcparam() added parameter "@estado"
> 17:46:40.178490 dbrpcparam() added parameter "@saldo"
> 17:46:40.178498 dbrpcparam() added parameter "@cliente"

Here are 6 parameters.

> 17:46:40.178507 dbrpcsend()
> 17:46:40.178519 parm_info_alloc(): parameter null-ness = 0
> 17:46:40.178531 param_row_alloc, size = 4, offset = 4, row_size = 8
> 17:46:40.178541 param_row_alloc(): doing data from value
> 17:46:40.178549 param_row_alloc(): setting parameter #0 to NULL
> 17:46:40.178558 setting column 0 NULL bit

1

> 17:46:40.178567 parm_info_alloc(): parameter null-ness = 0
> 17:46:40.178580 param_row_alloc, size = 80, offset = 8, row_size = 88
> 17:46:40.178590 param_row_alloc(): doing data from value
> 17:46:40.178598 param_row_alloc(): copying 80 bytes of data
> to parameter #1

2

> 17:46:40.178608 parm_info_alloc(): parameter null-ness = 0
> 17:46:40.178619 param_row_alloc, size = 80, offset = 88,
> row_size = 168
> 17:46:40.178628 param_row_alloc(): doing data from value
> 17:46:40.178636 param_row_alloc(): copying 80 bytes of data
> to parameter #2

3

> 17:46:40.178651 parm_info_alloc(): parameter null-ness = 0
> 17:46:40.178665 param_row_alloc, size = 4, offset = 168,
> row_size = 172
> 17:46:40.178675 param_row_alloc(): doing data from value
> 17:46:40.178683 param_row_alloc(): copying 4 bytes of data to
> parameter #3

4

> 17:46:40.178693 parm_info_alloc(): parameter null-ness = 0
> 17:46:40.178703 param_row_alloc, size = 8, offset = 172,
> row_size = 180
> 17:46:40.178713 param_row_alloc(): doing data from value
> 17:46:40.178721 param_row_alloc(): copying 8 bytes of data to
> parameter #4

5

> 17:46:40.178730 parm_info_alloc(): parameter null-ness = 0
> 17:46:40.178741 param_row_alloc, size = 4, offset = 180,
> row_size = 184
> 17:46:40.178751 param_row_alloc(): doing data from value
> 17:46:40.178759 param_row_alloc(): copying 4 bytes of data to
> parameter #5

6 (last)

> 17:46:40.178768 tds_free_all_results()
> 17:46:40.178779 tds_put_data_info putting param_name
> 17:46:40.178790 tds_put_data_info putting status
> 17:46:40.178799 tds_put_data: is_null = 1, colsize = 4
> 17:46:40.178808 tds_put_data: null param
>

It could be a problem with nulls. Which FreeTDS version are you using?
Could you try to repeat test with first parameter only? Or just post
first two dbrpcparam calls.

>
> Anyone can tell me what means and what is wrong if it is the
> case?...thanks

bye
freddy77





Archive powered by MHonArc 2.6.24.

Top of Page