How to pass string with a ' to PL/SQL

[laura pena]

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 refcursor
var 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:
:= . ( @ % ; immediate
The symbol ";" was substituted for "" to continue.

 

Thanks in advance.

 

-Lizz

---

Do you Yahoo!?
Free online calendar with sync to Outlook(TM).