Need help in finding an Oracle Exception.. Java+Oracle+Prepared Statement

Forgive me if this question is very vague

Some time back i faced this issue.

I used java and wrote a prepared statement INSERT into a table that had a few CLOBS. I inserted the records in the same order of the columns and got a SQL exception. The question is about this exception only.. I completely forgot what this exception is about

When i googled about the exception, the solution said CLOB's must always be inserted at the end and not somewhere in the middle even though the column occurs somewhere in the middle of the table.

I did that and the issue vanished. Now does any expert know which exception i am talking about? Please forgive me if i am not giving enough information. This is what I have

Answers


Whether you should insert blobs at the end will depend on your database and the driver. To be honest, I would consider it a bug in the driver if it required the users to handle this implementation detail of the database, instead of the driver taking care of it.


Need Your Help

How to detect change in network with Reachability?

iphone objective-c cocoa-touch reachability

I'm currently checking network connection on viewDidLoad using this:

Changing a textbox based on a dropdown html array with jQuery

javascript jquery html

So I am finding issues doing this, I am curious if its because I am using HTML form arrays.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.