How to pass string with a ' to PL/SQL

I have procedure that needs to pass a string with a ' . Anyone have any idea how to do this in PL/SQL
 

Here is my example:
 

var a refcursorvar b varchar2(100);begin   :b :='and sub_account_no=''864240103''';   execute :a := pkg_reports_Dynamiccti.fu_sales_analysis('2003-05-21 00:00:00','2003-06-02 00:00:00','20','864240103','order by calldate desc',:b);end;/ This is giving me an error.
ERROR at line 3:ORA-06550: line 3, column 12:PLS-00103: Encountered the symbol "" when expecting one of the following::= . ( @ % ; immediateThe symbol ";" was substituted for "" to continue.
 

Thanks in advance.
 

-Lizz
Do you Yahoo!?
Free online calendar with sync to Outlook(TM). Received on Tue Jun 10 2003 - 11:37:29 CDT