Hi Mickael,
As you adviced me i used raw SQL with $dbh->do() method and it did the
trick.
Thanks for you help.
Regards
Emmanuel
Le 28 août 2009 à 20:36, Michael Peppler <[email protected]> a
écrit :
Hi,
Sybase definitely treats a TEXT column as a "blob", and as the
DBD::Sybase docs mention it is not possible to pass such a column as
a placeholder.
You must pass the values directly as raw SQL text, or use the text/
image API provided by DBD::Sybase.
Michael
On Aug 28, 2009, at 4:16 PM, Emmanuel Quevillon wrote:
Hi,
I didn't know to which mailing list I should send this message, so
I'm cc'ing to DBIx::Class as it uses this framework. However, the DB
is Sybase 12.5.3.
The thing is that I want to do a large update of a certain amount of
rows. What I've to do is replace some kind of a date string into a
text field. If I send the query generated by DBIx::Class by hand to
the server, it works perfectly and to the update.
However, if I let the perl code (DBIC) doing it itself, I get the
following error thrown by Sybase:
DBI Exception: DBD::Sybase::db prepare failed: Server message
number=2782 severity=16 state=1 line=1 server=CRBIPTEST
procedure=DBD2 text=An untyped variable in the PREPARE statement
'DBD2' is being resolved to a TEXT or IMAGE type. This is illegal in
a dynamic PREPARE statement.
[for Statement "UPDATE produit SET HISTORIQUE = ? WHERE (
CODE_PRODUIT_CRBIP = ? )"] at
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/Class/Schema.pm line 1025
Here is the request generated:
UPDATE produit SET HISTORIQUE = ? WHERE ( CODE_PRODUIT_CRBIP = ? ):
'1993 R. Landen
1993 - 1998 M.M. Lecadet IP
1998 - 2001 B. Papierok IP
2001 - 2008 J.F. Charles IP
2009 C. Bizet IP', 'CRBIPbIEBC1048'
So I though the problem could come from the fact that the text field
contains some carriage return and causes Sybase not to understand
correctly the request?
On colleague also told me it could come from the fact that DBI
treats text field as BLOB????? Never head of this.
If someone could light my lantern.....
Thanks in advance
Regards
--
-------------------------
Emmanuel Quevillon
Biological Software and Databases Group
Institut Pasteur
+33 1 44 38 95 98
tuco at_ pasteur dot fr
-------------------------
Michael Peppler
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
"A successful [software] tool is one that was used to do something
undreamed of by its author." -- S. C. Johnson
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
