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
> Is there any function to insert special character into the table?
There is nothing special that you have to do. What is the full exception?
Retrieving data ...