Re: Passing Quotes to procedures in PL/SQL

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Sat, 18 Apr 1998 13:03:29 +0800
Message-ID: <35383421.47C1@bhp.com.au>

Poorna Prakash wrote:
>
> Folks.
>
> I was reading a message about how to pass parameters with single
> quotes to procedures in PL/SQL. Could you please repost with your
> hints please.
>
> Thanks
>
> -Peter

Try (for example)

SQL> exec my_proc ( my_string => 'Peter O''Brien');

HTH
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"These views mine not BHP..etc etc"

"The only difference between me and a madman is that I am not mad." Received on Sat Apr 18 1998 - 00:03:29 CDT