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



          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.