RE: How to pass string with a ' to PL/SQL

Laura,

Would
you try this?
<FONT face=Arial color=#0000ff
size=2> 

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;/
<FONT face=Arial color=#0000ff
size=2>Regards
<FONT face=Arial color=#0000ff
size=2>Vadim

  <FONT face=Tahoma
  size=2>-----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 <A
  href="http://us.rd.yahoo.com/mail_us/tag/*http://calendar.yahoo.com">online   calendar with sync to Outlook(TM). Received on Tue Jun 10 2003 - 17:44:31 CDT