Vipul Shah 2 Posted January 16, 2015 Share Posted January 16, 2015 Inserting String into CLOB column in Oracle DB table Hi All, I am trying to insert large string into CLOB column in Oraclevia BW Designer. I am able to insert data if I use "JDBC Update" palette with one of the parameter as 'CLOB' and passing incoming string to this prepared parameter in input tab. But same insert statement is not working with "Sql Direct " palette. Its throwing "ORA-01704 String literal too long". Any body faced such issue and able to reslove it Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted January 23, 2015 Share Posted January 23, 2015 are you using the tibcosoftwareinc.jdbc.oracle.OracleDriver driver or other database driver Link to comment Share on other sites More sharing options...
Vipul Shah 2 Posted October 23, 2015 Author Share Posted October 23, 2015 If I try to insert string of length 5000 with Sql Direct ...... Link to comment Share on other sites More sharing options...
Vipul Shah 2 Posted October 23, 2015 Author Share Posted October 23, 2015 Hi All, Has anybody faced this issue any pointers will be helpful Link to comment Share on other sites More sharing options...
Vipul Shah 2 Posted October 23, 2015 Author Share Posted October 23, 2015 Yes same driver tibcosoftwareinc.jdbc.oracle.OracleDriver . Link to comment Share on other sites More sharing options...
Gayatri Nikam Posted February 14, 2018 Share Posted February 14, 2018 Yes, I am also facing same issue with SQL direct when storing Json in CLOB. Does anyone have resolution for this issue Link to comment Share on other sites More sharing options...
Ben Warrick Posted January 17, 2020 Share Posted January 17, 2020 I think this is due to limitations on the size of the values passed into the prepared statement. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now