Skip to Content
avatar image
Former Member

Help on JDBC receiver Sql

Hi all,

I am using receiver jdbc adapter to insert data into oracle database, but I need to use single quote to make value as string, for example:

insert into ztable (id , name, description) values( 1, 'Jonathan', 'this is description(simple)' );

if I don't use QUOTE here, I will get error because there are "(" ")" in the DESCRIPTION value.

I see some threads mentioned to add attribute hasQuot= YES to realize this function, but I have tried, nothing happened, is there any tricks to make this happen?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jun 27, 2007 at 08:42 AM

    another question is ,I don't know how to insert date data into oracle, do I need to do some conversion, if I get 2007-06-27 from SAP, what I need to do to convert this date to Oracle date type, then insert it into oracle DB?

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2007 at 08:51 AM

    Can you provide us with the target XML that is casuing this issue,.

    normally, hasQuot = 'YES' does the trick. Maybe there is someother issue.

    Regards

    Bhavesh

    Add comment
    10|10000 characters needed characters exceeded