varchar2 parameter in stored procedure

[kcosgayon]

Hello,
I have a java program that creates a dynamic SQL statement with where clause. Is it possible to pass the query string (with string where clauses name = 'John") as a parameter in a stored procedure? I tried to do it but it does not work because of the single quotes. Please help anyone.
Regards,
kcosgayon

[debasisdas]

that can be done

can you please post your coracle code for my reference