hi do this

declare
a varchar2(200);
ip date := '23-SEP-75';
op varchar2(100);
begin
a := 'select TO_CHAR(TO_DATE('||CHR(39)||ip||CHR(39)||',''DD-MON-YY'')) FROM dual';
execute immediate a INTO op;
dbms_output.put_line(op);
end;


the CHR(39) is nothin but single quots

writeback @
[email protected]