1 Reply Latest reply on Jul 15, 2015 8:09 AM by Steven Hawkins

    How to insert special characters into table in teiid VDB

    govindaraj s Novice

      Hi,

       

          I have a Stored Procedure in teiid VDB, which is used to insert records in the physical database, it is working fine for normal characters

       

          If i try to insert any special characters like '$','&','%', then it returns some error like

       

        java.lang.StringIndexOutOfBoundsException: String index out of range:

       

          For example: INSERT INTO TABLE_NAME VALUES (123456, 'Enter@321', 'Password$1', 'A&B');


          Is there any function to insert special character into the table?

       

       

      Thanks & Regards

      Govindaraj s.