Re: writing CLOB data to Oracle 8 using CallableStatements

don't crosspost.

anyway, have a look on the orcle website, you may need an account but it is free.
they have some sample applications in the java section that do what you require.
but it will be a little slow.

steve  

Michael Lawless <syadnasti_at_hotmail.com> wrote:

> Can anyone tell me how to write large XML documents as strings to
> Oracle 8 CLOB fields using CallableStatements or refer me to a site
> that does this?
>
> How do I create the Clob object from the CallableStatement? Do i need
> to do this or am I missing something?
>
> I have looked at lots of posts on newsgroups and websites and cannot
> find a solution that doesn't use the ResultSet.getClob(int) function.
>
> I have tried this...
>
> oracle.jdbc.OracleConnection oralConn =
> (oracle.jdbc.OracleConnection)myConn;
> oracle.sql.CLOB myClob = new oracle.sql.CLOB(oralConn);
>
> But get a Constructor not defined error even though the auto complete
> in VisualAge presents it.
>
> If there is a solution will I face the 4000byte limit problem.
>
> Thanks in advance.
Received on Sat Jan 19 2002 - 15:39:11 CST