Problem with DBD::ODBC : -DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL Server]Procedure has no parameters and arguments were supplied. (SQL-42000)(DBD: st_execute/SQLExecute err=-1)

When I try to run a perl script that uses ODBC drivers to insert data
more than 70000 rows I am getting the following error....

DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL
Server]Procedure  has no parameters and arguments were supplied.
(SQL-42000)(DBD: st_execute/SQLExecute err=-1) [for Statement "INSERT
INTO
db.guest.portfolio_event_1_310_3560_3(col1,col2,col3,col4,col4,col5)
VALUES (?,?,?,?,?)" with ParamValues:  4=' ', 1='1754079', 2=' ',
3='0', 5=' '] at /usr/local/lib/perl5/site_perl/5.8.6/DBIx/
ContextualFetch.pm line 51

Could someone help me in this aspect......

Thanks,
    Neel

0
jnp
12/12/2007 6:48:30 AM
perl.dbi.users 11100 articles. 1 followers. Follow

1 Replies
1626 Views

Similar Articles

[PageSpeed] 35

jnp.swiss@gmail.com wrote:
> When I try to run a perl script that uses ODBC drivers to insert data
> more than 70000 rows I am getting the following error....
> 
> DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL
> Server]Procedure  has no parameters and arguments were supplied.
> (SQL-42000)(DBD: st_execute/SQLExecute err=-1) [for Statement "INSERT
> INTO
> db.guest.portfolio_event_1_310_3560_3(col1,col2,col3,col4,col4,col5)
> VALUES (?,?,?,?,?)" with ParamValues:  4=' ', 1='1754079', 2=' ',
> 3='0', 5=' '] at /usr/local/lib/perl5/site_perl/5.8.6/DBIx/
> ContextualFetch.pm line 51
> 
> Could someone help me in this aspect......
> 
> Thanks,
>     Neel
> 
> 

It is a SQL Server error reported by the FreeTDS ODBC Driver. I would 
not rule out DBD::ODBC but:

"Procedure  has"

looks like something (FreeTDS perhaps) was attempting to call a 
procedure but for some reason the name is not known (look at the two 
spaces between "Procedure" and "has". I don't use FreeTDS myself but I 
do know that for "insert into...." DBD::ODBC is not going to call any 
procedures itself.

Has your table perhaps got triggers associated with it?

Martin
-- 
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
0
martin
12/12/2007 1:37:37 PM
Reply: