PL-SQL HELP

From: Viktor <stant_98_at_yahoo.com>
Date: Mon, 9 Oct 2000 09:24:13 -0700 (PDT)
Message-Id: <10644.118799@fatcity.com>

Hi, all!

Can someone help me convert this lines to ORACLE PL-SQL:
select @idseq = substring(@nameid,5,1)
if select patindex("%[a-z,A-Z,*,?,!,,,(,)",@idseq) > 0 begin
select "error|incorrect id
 return -998
end
else
 select @revseq = convert(smallint,@idseq)

What this supposed to accomplish is that it should exit out of the procedure and warn user that the string should not contain non-integer values.

Thanks.

---

Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free! http://photos.yahoo.com/ Received on Mon Oct 09 2000 - 11:24:13 CDT