Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to pass string with a ' to PL/SQL - Solved -Thanks.

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

From: laura pena <lizzpenaorclgrp_at_yahoo.com>
Date: Wed, 11 Jun 2003 07:54:43 -0700
Message-ID: <F001.005AF114.20030611070003@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US