Re: [GENERAL] passing text value with single quote to stored procedure

2013-07-13 Thread Alban Hertroys
On Jul 13, 2013, at 24:05, Prabhjot Sheena wrote: > when this value is passed to the function > > select load_stage_start_v1('QA_SUMMER'2013_(EU/US)'); > > This gives an error. Is there a way to fix this issue. Your issue has nothing to do with stored procedures. You need to escape the stri

Re: [GENERAL] passing text value with single quote to stored procedure

2013-07-12 Thread Adrian Klaver
On 07/12/2013 03:05 PM, Prabhjot Sheena wrote: Hi all I am currently having an issue with passing a value with a single quote in it to stored procedure i am trying to pass this text value QA_SUMMER ' 2013_(EU/US) to stored procedure text variable. it gives me error. Here is more de

[GENERAL] passing text value with single quote to stored procedure

2013-07-12 Thread Prabhjot Sheena
Hi all I am currently having an issue with passing a value with a single quote in it to stored procedure i am trying to pass this text value QA_SUMMER ' 2013_(EU/US) to stored procedure text variable. it gives me error. Here is more detail on this My stored procedure is something like