escape characters in PL/SQL

From: polywog <polywog_at_drexel.edu>
Date: Wed, 09 Jun 1999 15:04:14 -0400
Message-ID: <375EBAAE.A89B1ED4_at_drexel.edu>

[Quoted] How do i escape characters in PL/SQL. For example when i declare this:

  SQL_WHERE_APREXCL VarChar2(32) := 'and aprcatg_pidm = aprexcl_pidm(+) ';

it errors at this:

	ERROR at line 1:
	ORA-06502: PL/SQL: numeric or value error
	ORA-06512: at line 85

I have narrowed it down to the '(' and '+' and ')' how do i escape these symbols? I have tried \ and '''' and ''' to no avail. Some help would be appreciated. =)

ciao, elmo

-- 

Elmo Recio; Philadelphia, PA 19103; USA
Email: polywog_at_drexel.edu
Homepage: http://polywog.navpoint.com/~elmo
Sociology/Philosophy student at Drexel Univ

Oracle Applications Development at OIT_at_TJU
Linux Project Co-ordinator at OIT_at_TJU

"so, drink, drink, drink
 and be ill tonight
 from the one you left behind
 from the one you left behind
 from the one you left behind
 from the one you left behind
 XXXXXXXXX "
-Smiths (Unhappy Birthday)

Received on Wed Jun 09 1999 - 21:04:14 CEST