Hi,
I have a sql program which accepts 5 parameters. One of them is a text.
Some times it can have ' (quote).
var := '&1';
Trying to replace single quote with double.
How can I do it as program fails on the assignment itself
var := '&1';
ORA-01756: quoted string not properly terminated
replace commands also same error.
This is called by many programs. We would like to change in this one program instead of all calling program do the replace.
thanks