Xref: alice comp.databases.oracle.tools:24330
Path: alice!news-feed.fnsi.net!netnews.com!howland.erols.net!newsfeed.cwix.com!206.86.34.12!nuq-peer.news.verio.net!uunet!lax.uu.net!ffx.uu.net!in2.uu.net!news.gate.net!not-for-mail
From: "sam cappello" <samc@gate.net>
Newsgroups: comp.databases.oracle.tools
Subject: Re: FORMS: What else can I use besides single quote for specifying literal value?
Date: Tue, 4 May 1999 23:23:19 -0400
Organization: CyberGate, Inc.
Lines: 31
Message-ID: <7godkr$1bbg$1@news.gate.net>
References: <tKLX2.46$xr4.4573490@IConNet>
X-Trace: news.gate.net 925874651 44400 207.36.133.116 (5 May 1999 03:24:11 GMT)
X-Complaints-To: abuse@gate.net
NNTP-Posting-Date: 5 May 1999 03:24:11 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211

try 'claim_type = ''HP'''  or  'claim_type = '||chr(39)||'HP'||chr(39)  - it
might be better to set a variable to this and then use the variable in the
SET_BLOCK_PROPERTY -
declare x_wc varchar2(50);
.
.
x_wc := 'claim_type = '||chr(39)||'HP'||chr(39);
SET_BLOCK_PROPERTY('claim', default_where, x_wc);

hope this helps!
sam

Atsuko Miller <amiller@rhs.org> wrote in message
news:tKLX2.46$xr4.4573490@IConNet...
> I'm trying to do the following.....
>
> SET_BLOCK_PROPERTY('claim', default_where, 'claim_type = 'HP'');
>
> I need to use quote around the 3rd parameter but I also need to use single
> quote around  HP since it is a literal value.....but it does not let me
> compile it.
> Is there a character to replace single quote for literal value?????  or do
> you know the work around????
>
> I'd appreciate your response.   Thank you     :-)
>
>
>
>