Comments for Observing Oracle

Comment on Tuning Collections in Queries [Introduction] by sandrar

sandrar — Thu, 10 Sep 2009 14:28:09 +0000

Hi! I was surfing and found your blog post… nice! I love your blog. Cheers! Sandra. R.

Comment on ORA-01461: can bind a LONG value only for insert into a LONG column by sgaur

sgaur — Wed, 02 Sep 2009 18:42:49 +0000

Thanks very much. You saved my day!

Comment on ORA-01461: can bind a LONG value only for insert into a LONG column by Alexandru Barbat

Alexandru Barbat — Wed, 08 Jul 2009 14:55:17 +0000

I have the same issue on websphere 7.0 with 11.1.0.7.0-Production driver(ojdbc6.jar)
On tomcat 6.0.18 i don’t get the error even if use the 11.1.0.7.0 or 9.0.2.0.0 driver version.

I use the same database for each of those two cases.

Comment on ORA-01461: can bind a LONG value only for insert into a LONG column by Vijay M

Vijay M — Fri, 12 Jun 2009 16:05:13 +0000

I am on 11.1.0.7.0. and its driver.
Still getting the same error.

Any workaround?

Comment on Tuning Collections in Queries [1] by Venkat

Venkat — Thu, 11 Jun 2009 06:28:57 +0000

Of the given 2 subject SQL statement, i see that the former(1) is more optimal than (2). (1) has better cardinality than (2).
I did not use any hints.

Your thoughts?

Comment on Recursive Calls by BipNouppy

BipNouppy — Sat, 23 May 2009 04:37:04 +0000

emm. strange ))

Comment on ORA-01461: can bind a LONG value only for insert into a LONG column by Aniceto Perez

Aniceto Perez — Fri, 13 Jun 2008 15:58:58 +0000

I’ve tried this with drivers ver 10.2.0.3, 10.2.0.4 and always the same error:

update mytable (keyFileld, xmltypeField) values (?, xmltype(?))

If the xml content is not longer than 4K, it works.

Any ideas?

Comment on Tuning Collections in Queries [1] by Vlad Sadilovskiy

Vlad Sadilovskiy — Thu, 05 Jun 2008 16:28:27 +0000

Hi Sukumar,

Thanks for the feedback. The credits should also be allowed to Tom Kyte and Jonathan Lewis for the thoughts they had given on asktom.com.

Now I’m in the process of researching and developing framework that would allow this matter be seamlessly used in applications that use collections via Hibernate/EJB3 infrastructure.

Comment on ORA-01461: can bind a LONG value only for insert into a LONG column by Vlad Sadilovskiy

Vlad Sadilovskiy — Thu, 05 Jun 2008 16:19:56 +0000

Loïc Lefèvre, thanks for pointing this out. We are in the process of testing few applications on 10.2.0.4 Oracle patchset. And this is one of the tests we planned to do. I will comment on it once it is done.

Comment on ORA-01461: can bind a LONG value only for insert into a LONG column by Loïc Lefèvre

Loïc Lefèvre — Thu, 05 Jun 2008 15:35:46 +0000

For your information, the 10.2.0.4 driver is rolled out. Do you encounter the same problems with this version?

Regards,
Loïc Lefèvre