Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

I am trying to insert large string into CLOB column in Oracle via BW Designer.


Vipul Shah 2

Recommended Posts

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

  • 9 months later...
  • 2 years later...
  • 1 year later...
×
×
  • Create New...