web stats
Inserting CLOB data in an Oracle database - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 04-26-2018, 08:31 AM
grp02 grp02 is offline
What's HL7?
 
Join Date: Feb 2018
Posts: 4
grp02 is on a distinguished road
Red face Inserting CLOB data in an Oracle database

Posted in other forum, but no response. Any help is appreciated.

I'm trying to insert CLOB data into a table

I'm trying to save an XML message in the column in an Oracle database.

First, I have inserted EMPTY_CLOB() in the column and then updated the XML data in that column that didn't work, tired some solutions as suggested on this forum, but nothing worked.

Is there any updated solution for inserting XML data into a CLOB datatype ?? I'm using Mirth 3.5.1.
Reply With Quote
  #2  
Old 05-16-2018, 06:46 AM
AlexNeiva AlexNeiva is offline
Mirth Guru
 
Join Date: Oct 2013
Location: Portugal
Posts: 275
AlexNeiva is on a distinguished road
Default

Hello,

i found this on the Web:

Code:
Clob clob = connection.createClob(); 
clob.setString(1, str);
It is Java code, but you can adapt or use in Mirth also.
Give it a try...
__________________
Best Regards,
Alex Neiva
Reply With Quote
  #3  
Old 05-16-2018, 06:48 AM
AlexNeiva AlexNeiva is offline
Mirth Guru
 
Join Date: Oct 2013
Location: Portugal
Posts: 275
AlexNeiva is on a distinguished road
Default

Quote:
Originally Posted by AlexNeiva View Post
Hello,

i found this on the Web:

Code:
Clob clob = connection.createClob(); 
clob.setString(1, str);
It is Java code, but you can adapt or use in Mirth also.
Give it a try...
Even better, check this link, i guess it will help you:

https://www.mirthcorp.com/community/...read.php?t=895
__________________
Best Regards,
Alex Neiva
Reply With Quote
Reply

Tags
clob, oracle

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 03:08 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation