>It is big problem for me as the SQL statement is generated
>by the program and it need "" symbol for oracle
SQL does NOT use or want double quote marks as shown above.
SQL can require single quote marks.
Where SQL wants/expects single quote marks I concatentate into the string CHR(39); such as ...
v_where_clause := 'WHERE P_KEY = ' || CHR(39) || 'ABC' || CHR(39);
After this statement execute v_where_clause contains:
WHERE P_KEY = 'ABC'