ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » Search

 Search found 3 matches
Author Message
  Topic: ESQL to Oracle 9i XMLType Column
Goon Bottle

Replies: 4
Views: 4323
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Thu Jan 19, 2006 2:05 am   Subject: ESQL to Oracle 9i XMLType Column
Ian many thanks for this. I shall have to try and invent a work-around.
  Topic: ESQL to Oracle 9i XMLType Column
Goon Bottle

Replies: 4
Views: 4323
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Tue Jan 17, 2006 8:21 am   Subject: ESQL to Oracle 9i XMLType Column
Tried PASSTHRU() and it didn't do anything for me. I was expecting something as simple as;

INSERT INTO Database.mySchema.myTable(textcol, xmlcol) VALUES ("Hello World", InputRoot.XML.Message);

t ...
  Topic: ESQL to Oracle 9i XMLType Column
Goon Bottle

Replies: 4
Views: 4323
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Tue Jan 17, 2006 7:37 am   Subject: ESQL to Oracle 9i XMLType Column
Does anyone have a solution for inserting XML into an Oracle 9 XMLType column. Despite various different ESQL attempts I either get NULL or have to use a CLOB column. There are processes on the databa ...
Page 1 of 1

Jump to:  
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.