Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Field scan question - PL/SQL trigger
>Subject: Field scan question - PL/SQL trigger
>From: Jim.Pickett_at_cubic.com
>Date: 1/14/98 11:32PM GMT
>Message-id: <Forum.884821104.31171.Pickett_at_ferret.corp.cubic.com>
>
>
>Dear PL/SQL Gurus:
>
>I have been asked to develop a trigger that will allow me to parse
>a VARCHAR2(30) field to see if it contains an asterisk or double
>quote.
>
>The existence of either of these two characters within the field is
>causing an application error in our CODA A/P system.
>
>Is there a syntax or function that will allow me to inspect the entire
>field for the existence of these specific characters.
>
>We are using PL/SQL version 2.3 if it matters.
>
>Please reply to my e-mail below as well as the board as I don't get the
>opportunity to "visit" as frequently as i'd like.
>
>Thanks in advance.
>
>======================================
> Jim Pickett
> Cubic Corporation
>
> Work: (619)505-2868
> Pager: (619)494-5539
> E-mail: jim_pickett_at_cubic.com
>
> 01/14/98 15:32:17
>======================================
>
>
>
>
>
>
>
>
>
Check out the INSTR function Received on Thu Jan 15 1998 - 00:00:00 CST
![]() |
![]() |