Oracle Forms

hi friends,

I am using a forms_dll statement in my form. where i am facing problem while inserting data using it.

i am using following code

forms_ddl('Insert into '||:global.tab_name||' values ( '||:global.SeqAge||','||to_char(col_code)||','||''''||col_desc||''' )');


where col_desc is B'Lore

now as B'lore contains ' in it the forms_ddl statement is failing.

Is there any way that i can handle it.

Please help

thanks in advance
sachin