Converting a stored procedure from Sybase

From: <johnchewter_at_my-deja.com>
Date: Wed, 15 Dec 1999 10:13:36 GMT
Message-ID: <837pke$n8p$1@nnrp1.deja.com>

I've got the following stored procedure in a Sybase database and now need to do the same using Oracle:

create proc test( @P varchar(255) )
as
declare @w varchar(20)
declare @c int

select @w as "UserID" into #res where 0 = 1
select @c = charindex(',', @P)
while (@c<>0) begin

  select @w = substring(@P, 1, @c-1)
  select @P = substring(@P, @c+1, 200)
  insert into #res values (ltrim(rtrim(@w)))   select @c = charindex(',',@P)
end
insert into #res values (ltrim(rtrim(@U))) select UserID from Users where UserID in (select UserID from #res) return

any help appreciated.
John

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 15 1999 - 04:13:36 CST