Re: [cx-oracle-users] ORA-01461: can bind a LONG value only for insert into a LONG column
Brought to you by:
atuining
Menu
▾
▴
Re: [cx-oracle-users] ORA-01461: can bind a LONG value only for insert into a LONG column
|
From: Vladislav N. <vla...@go...> - 2008-11-07 15:05:03
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Anthony,<br>
<br>
thank you very much for your quick answer... now it works<br>
<br>
Best regards<br>
Vladislav Nazarenko<br>
<br>
<br>
Anthony Tuininga schrieb:
<blockquote
cite="mid:703...@ma..."
type="cite">
<pre wrap="">Hi,
Can you specify what version of cx_Oracle you are using? There have
been a few improvements over the years... :-)
No matter what version you are using, though, you can always use
setinputsizes() to specify. In other words, something like this:
cursor.setinputsizes(thevalue = cx_Oracle.LONG_BINARY)
cursor.execute("insert into thetable (thecolumn) values (:thevalue)",
thevalue = "X" * 60000)
That should work for you. You can see some of these techniques in the
test suite as well.
Anthony
On Fri, Nov 7, 2008 at 6:55 AM, Vladislav Nazarenko
<a class="moz-txt-link-rfc2396E" href="mailto:vla...@go..."><vla...@go...></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hello!
I have a little question... I'm trying to write a zip file in a oracle
db(9.2.x.x)... The Column type is LONG ROW...
If the file size is smaller than 10 K, I have no troubles, but if it's
more, I get the following error:
ORA-01461: can bind a LONG value only for insert into a LONG column
The Column can take 70 K
Query:
insert [TABLE NAME] ( test_column ) values ( utl_raw.cast_to_row([file
content]) )
Could you please explain me, how can I avoid this ...
Thanks a lot
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
<a class="moz-txt-link-freetext" href="http://moblin-contest.org/redirect.php?banner_id=100&url=/">http://moblin-contest.org/redirect.php?banner_id=100&url=/</a>
_______________________________________________
cx-oracle-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:cx-...@li...">cx-...@li...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/cx-oracle-users">https://lists.sourceforge.net/lists/listinfo/cx-oracle-users</a>
</pre>
</blockquote>
<pre wrap=""><!---->
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
<a class="moz-txt-link-freetext" href="http://moblin-contest.org/redirect.php?banner_id=100&url=/">http://moblin-contest.org/redirect.php?banner_id=100&url=/</a>
_______________________________________________
cx-oracle-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:cx-...@li...">cx-...@li...</a>
<a class="moz-txt-link-freetext" href="https://lists.sourceforge.net/lists/listinfo/cx-oracle-users">https://lists.sourceforge.net/lists/listinfo/cx-oracle-users</a>
</pre>
</blockquote>
<br>
</body>
</html>
|
