Skip to Content.
Sympa Menu

freetds - [freetds] Can't write to DB using stored procedure

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Bodo Schulze <bobesch AT letras.net>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Can't write to DB using stored procedure
  • Date: Fri, 15 May 2009 14:29:10 +0000

Hi guys,

using FreeTDS v0.82 and DBD::Sybase v1.09 on a Linux box with Perl
v5.8.5 I'm executing a stored procedure that should create a new member
and return its ID.

But while DBD::Sybase throws no error, execute() invariably returns -1,
meaning that the number of rows affected is unknown.

My client confirms that there is no problem with the underlying stored
procedure (to which I have no access).

I tried several approachs (with positioned and with named params, with
and without placeholders), but the result is invariably that execute
returns -1.

Any ideas? Maybe the DBI trace below can help?

Warmest regards,

Bodo

<dbi.trace>
DBI::db=HASH(0x975a288) trace level set to 0x0/15 (DBI @ 0x0/0) in DBI
1.53-ithread (pid 15315)
-> prepare for DBD::Sybase::db (DBI::db=HASH(0x97449e0)~0x975a288 'EXEC
RegisterNewMember ?,?,?,?,?,?,?,?,?,?,?,?,? ') thr#8db4008
dbih_setup_handle(DBI::st=HASH(0x975b0d4)=>DBI::st=HASH(0x97ae190),
DBD::Sybase::st, 975b0e0, Null!)
dbih_make_com(DBI::db=HASH(0x975a288), 975b740, DBD::Sybase::st, 420, 0)
thr#8db4008
dbih_setup_attrib(DBI::st=HASH(0x97ae190), Err, DBI::db=HASH(0x975a288))
SCALAR(0x95f17f8) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x97ae190), State,
DBI::db=HASH(0x975a288)) SCALAR(0x95f1858) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x97ae190), Errstr,
DBI::db=HASH(0x975a288)) SCALAR(0x95f1828) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x97ae190), TraceLevel,
DBI::db=HASH(0x975a288)) 15 (already defined)
dbih_setup_attrib(DBI::st=HASH(0x97ae190), FetchHashKeyName,
DBI::db=HASH(0x975a288)) 'NAME' (already defined)
dbih_setup_attrib(DBI::st=HASH(0x97ae190), HandleSetErr,
DBI::db=HASH(0x975a288)) undef (not defined)
dbih_setup_attrib(DBI::st=HASH(0x97ae190), HandleError,
DBI::db=HASH(0x975a288)) undef (not defined)
syb_st_prepare() -> inUse = 0
dbd_preparse parameter :p1 ()
dbd_preparse parameter :p2 ()
dbd_preparse parameter :p3 ()
dbd_preparse parameter :p4 ()
dbd_preparse parameter :p5 ()
dbd_preparse parameter :p6 ()
dbd_preparse parameter :p7 ()
dbd_preparse parameter :p8 ()
dbd_preparse parameter :p9 ()
dbd_preparse parameter :p10 ()
dbd_preparse parameter :p11 ()
dbd_preparse parameter :p12 ()
dbd_preparse parameter :p13 ()
dbd_preparse scanned 13 distinct placeholders
describe_proc: procname = RegisterNewMember
syb_alloc_cmd() -> CS_COMMAND 98936d8 for CS_CONNECTION 975cb28
syb_st_prepare() -> set inUse
<- prepare= DBI::st=HASH(0x975b0d4) at
/home/bodo/xxx/lib/Client/WebServices.pm line 156 via at
/home/bodo/xxx/lib/Client/WebServices.pm line 110
-> bind_param for DBD::Sybase::st (DBI::st=HASH(0x975b0d4)~0x97ae190 1
'james AT bond3.com' 12) thr#8db4008
bind :p1 <== 'james AT bond3.com' (attribs: )
<- bind_param= 1 at /home/bodo/xxx/lib/Client/WebServices.pm line 166 via
at /home/bodo/xxx/lib/Client/WebServices.pm line 110
-> bind_param for DBD::Sybase::st (DBI::st=HASH(0x975b0d4)~0x97ae190 2 5
-6) thr#8db4008
bind :p2 <== '5' (attribs: )
<- bind_param= 1 at /home/bodo/xxx/lib/Client/WebServices.pm line 166 via
at /home/bodo/xxx/lib/Client/WebServices.pm line 110
-> bind_param for DBD::Sybase::st (DBI::st=HASH(0x975b0d4)~0x97ae190 3
'myname3' 12) thr#8db4008
bind :p3 <== 'myname3' (attribs: )
<- bind_param= 1 at /home/bodo/xxx/lib/Client/WebServices.pm line 166 via
at /home/bodo/xxx/lib/Client/WebServices.pm line 110
-> bind_param for DBD::Sybase::st (DBI::st=HASH(0x975b0d4)~0x97ae190 4
'2058-02-02' 9) thr#8db4008
bind :p4 <== '2058-02-02' (attribs: )
<- bind_param= 1 at /home/bodo/xxx/lib/Client/WebServices.pm line 166 via
at /home/bodo/xxx/lib/Client/WebServices.pm line 110
-> bind_param for DBD::Sybase::st (DBI::st=HASH(0x975b0d4)~0x97ae190 5
'M' 12) thr#8db4008
bind :p5 <== 'M' (attribs: )
<- bind_param= 1 at /home/bodo/xxx/lib/Client/WebServices.pm line 166 via
at /home/bodo/xxx/lib/Client/WebServices.pm line 110
-> bind_param for DBD::Sybase::st (DBI::st=HASH(0x975b0d4)~0x97ae190 6
'england' 12) thr#8db4008
bind :p6 <== 'england' (attribs: )
<- bind_param= 1 at /home/bodo/xxx/lib/Client/WebServices.pm line 166 via
at /home/bodo/xxx/lib/Client/WebServices.pm line 110
-> bind_param for DBD::Sybase::st (DBI::st=HASH(0x975b0d4)~0x97ae190 7
12323 12) thr#8db4008
bind :p7 <== '12323' (attribs: )
<- bind_param= 1 at /home/bodo/xxx/lib/Client/WebServices.pm line 166 via
at /home/bodo/xxx/lib/Client/WebServices.pm line 110
-> bind_param for DBD::Sybase::st (DBI::st=HASH(0x975b0d4)~0x97ae190 8 0
-6) thr#8db4008
bind :p8 <== '0' (attribs: )
<- bind_param= 1 at /home/bodo/xxx/lib/Client/WebServices.pm line 166 via
at /home/bodo/xxx/lib/Client/WebServices.pm line 110
-> bind_param for DBD::Sybase::st (DBI::st=HASH(0x975b0d4)~0x97ae190 9 0
-6) thr#8db4008
bind :p9 <== '0' (attribs: )
<- bind_param= 1 at /home/bodo/xxx/lib/Client/WebServices.pm line 166 via
at /home/bodo/xxx/lib/Client/WebServices.pm line 110
-> bind_param for DBD::Sybase::st (DBI::st=HASH(0x975b0d4)~0x97ae190 10 0
-6) thr#8db4008
bind :p10 <== '0' (attribs: )
<- bind_param= 1 at /home/bodo/xxx/lib/Client/WebServices.pm line 166 via
at /home/bodo/xxx/lib/Client/WebServices.pm line 110
-> bind_param for DBD::Sybase::st (DBI::st=HASH(0x975b0d4)~0x97ae190 11
undef 12) thr#8db4008
bind :p11 <== '' (attribs: )
<- bind_param= 1 at /home/bodo/xxx/lib/Client/WebServices.pm line 166 via
at /home/bodo/xxx/lib/Client/WebServices.pm line 110
-> bind_param for DBD::Sybase::st (DBI::st=HASH(0x975b0d4)~0x97ae190 12
undef 4) thr#8db4008
bind :p12 <== '' (attribs: )
<- bind_param= 1 at /home/bodo/xxx/lib/Client/WebServices.pm line 166 via
at /home/bodo/xxx/lib/Client/WebServices.pm line 110
-> bind_param for DBD::Sybase::st (DBI::st=HASH(0x975b0d4)~0x97ae190 13
undef 4) thr#8db4008
bind :p13 <== '' (attribs: )
<- bind_param= 1 at /home/bodo/xxx/lib/Client/WebServices.pm line 170 via
at /home/bodo/xxx/lib/Client/WebServices.pm line 110
-> execute for DBD::Sybase::st (DBI::st=HASH(0x975b0d4)~0x97ae190)
thr#8db4008
bind :p1 () <== 'james AT bond3.com' (size 15/16/0, ptype 4, otype 0)
bind :p1 <== 'james AT bond3.com' (size 15, ok 1)
datafmt: type=0, name=, status=256, len=15
saved type: 0
bind :p2 () <== 5 (size 1/2/0, ptype 5, otype 0)
bind :p2 <== '5' (size 1, ok 1)
datafmt: type=0, name=, status=256, len=1
saved type: 0
bind :p3 () <== 'myname3' (size 7/8/0, ptype 4, otype 0)
bind :p3 <== 'myname3' (size 7, ok 1)
datafmt: type=0, name=, status=256, len=7
saved type: 0
bind :p4 () <== '2058-02-02' (size 10/11/0, ptype 4, otype 0)
bind :p4 <== '2058-02-02' (size 10, ok 1)
datafmt: type=0, name=, status=256, len=10
saved type: 0
bind :p5 () <== 'M' (size 1/2/0, ptype 4, otype 0)
bind :p5 <== 'M' (size 1, ok 1)
datafmt: type=0, name=, status=256, len=1
saved type: 0
bind :p6 () <== 'england' (size 7/8/0, ptype 4, otype 0)
bind :p6 <== 'england' (size 7, ok 1)
datafmt: type=0, name=, status=256, len=7
saved type: 0
bind :p7 () <== 12323 (size 5/6/0, ptype 5, otype 0)
bind :p7 <== '12323' (size 5, ok 1)
datafmt: type=0, name=, status=256, len=5
saved type: 0
bind :p8 () <== 0 (size 1/2/0, ptype 5, otype 0)
bind :p8 <== '0' (size 1, ok 1)
datafmt: type=0, name=, status=256, len=1
saved type: 0
bind :p9 () <== 0 (size 1/2/0, ptype 5, otype 0)
bind :p9 <== '0' (size 1, ok 1)
datafmt: type=0, name=, status=256, len=1
saved type: 0
bind :p10 () <== 0 (size 1/2/0, ptype 5, otype 0)
bind :p10 <== '0' (size 1, ok 1)
datafmt: type=0, name=, status=256, len=1
saved type: 0
bind :p11 () <== undef (NULL, ptype 4, otype 0)
bind :p11 <== '(null)' (size -1, ok 0)
datafmt: type=0, name=, status=256, len=0
saved type: 0
bind :p12 () <== undef (NULL, ptype 4, otype 8)
bind :p12 <== '(null)' (size -1, ok 0)
datafmt: type=8, name=, status=256, len=0
saved type: 8
bind :p13 () <== undef (NULL, ptype 0, otype 8)
bind :p13 <== '(null)' (size -1, ok 0)
datafmt: type=8, name=, status=256, len=0
saved type: 8
cmd_execute() -> ct_send() OK
cmd_execute() -> set inUse flag
st_next_result() -> ct_results(4043) == 1
ct_res_info() returns 1 columns
STORE DBI::st=HASH(0x97ae190) 'NUM_OF_FIELDS' => 1
ct_describe(0): type = 8, maxlen = 4
describe() -> col 0, type 8, realtype 8
describe() retcode = 1
st_next_result() -> lasterr = 0, lastsev = 0
<- execute= -1 at /home/bodo/xxx/lib/Client/WebServices.pm line 172 via
at /home/bodo/xxx/lib/Client/WebServices.pm line 172
-> fetchrow_array for DBD::Sybase::st (DBI::st=HASH(0x975b0d4)~0x97ae190)
thr#8db4008
dbih_setup_fbav for 1 fields => 0x97ae4b4
syb_st_fetch() -> ct_fetch() = 1 (1 rows, 1 cols)
syb_st_fetch() -> 0/4/8
<- fetchrow_array= ( 0 ) [1 items] row1 at
/home/bodo/xxx/lib/Client/WebServices.pm line 176 via at
/home/bodo/xxx/lib/Client/WebServices.pm line 110
-> finish for DBD::Sybase::st (DBI::st=HASH(0x975b0d4)~0x97ae190)
thr#8db4008
syb_st_finish() -> ct_cancel(CS_CANCEL_ALL)
clear_sth_flags() -> resetting ACTIVE, moreResults, dyn_execed, exec_done
clear_sth_flags() -> reset inUse flag
<- finish= 1 at /home/bodo/xxx/lib/Client/WebServices.pm line 187 via at
/home/bodo/xxx/lib/Client/WebServices.pm line 110
-> DESTROY for DBD::Sybase::st (DBI::st=HASH(0x97ae190)~INNER) thr#8db4008
syb_st_destroy: called on 98928e0...
syb_st_destroy(): freeing imp_sth->statement
ct_cmd_drop() -> CS_COMMAND 98936d8
syb_st_destroy(): cmd dropped: 1
<- DESTROY= undef at /home/bodo/xxx/lib/Client/WebServices.pm line 110
via at /home/bodo/xxx/lib/Client/WebServices.pm line 110
-> disconnect for DBD::Sybase::db (DBI::db=HASH(0x97449e0)~0x975a288)
thr#8db4008
syb_db_disconnect() -> ct_close()
<- disconnect= 1 at /home/bodo/xxx/lib/Client/WebServices.pm line 33 via
at /home/bodo/xxx/cgi/json.pl line 0
! -> DESTROY for DBD::Sybase::db (DBI::db=HASH(0x975a288)~INNER) thr#8db4008
! <- DESTROY= undef during global destruction
</dbi.trace>





Archive powered by MHonArc 2.6.24.

Top of Page