RE: How to pass string with a ' to PL/SQL - Solved -Thanks.

Yes this worked.
This is what I originally ... originally had !!! The problem seem to be with my code.
 

Pointed out by Jacques. My orderby clause was where the whereclause statement should be..
 
 

Thanks for the code review and feed back everyone. Learned a lot with this exercise.
 
 

"Gorbounov,Vadim" <[EMAIL PROTECTED]> wrote:

Laura,
Would you try this?
 

var a refcursorvar b varchar2(100);begin   :b :='and sub_account_no=''864240103''';   :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;/ Regards
Vadim

-----Original Message-----From: laura pena [mailto:[EMAIL PROTECTED]Sent: Tuesday, June 10, 2003 1:25 PMTo: Multiple recipients of list ORACLE-LSubject: 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). Do you Yahoo!?
Free online calendar with sync to Outlook(TM). Received on Wed Jun 11 2003 - 09:54:43 CDT