Publishing a special character into oracle database

[ram123]

We need help or suggestions for publishing a string value
STR1= "Characterization of the effect of surface area on testosterone gel 1.62% absorption";
into oracle data base through TI process.presently we are using directly ODBCOUTPUT

sqry = 'Insert into table1 (column1)
'|' Values ('''|str1|'''')';
odbcoutput(....)

please note the string STR1 has special character %

[David Usherwood]

This isn't a TM1 specific issue - you are building a string for Oracle to execute.
A quick google found lots of articles about special characters in Oracle:
http://docs.oracle.com/cd/F49540_01/DOC ... cqspcl.htm
http://stackoverflow.com/questions/9325 ... -an-insert

[ram123]

Do you mean I have to change orcle column?please give me some clarity on the changes I need to do at database level.
presently column type is varchar2(500byte).

[David Usherwood]

No.