Xref: alice comp.databases.oracle.misc:33950
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!dispose.news.demon.net!demon!news.demon.co.uk!demon!jlcomp.demon.co.uk!not-for-mail
From: "Jonathan Lewis" <jonathan@jlcomp.demon.co.uk>
Newsgroups: comp.databases.oracle.misc
Subject: Re: cursor parameter and SQL WHERE clause
Date: Sat, 19 Jun 1999 09:39:53 +0100
Message-ID: <929781822.23814.0.nnrp-04.9e984b29@news.demon.co.uk>
References: <7k9f7l$k0_001@its.csiro.au>
X-Trace: news.demon.co.uk 929781822 nnrp-04:23814 NO-IDENT jlcomp.demon.co.uk:158.152.75.41
X-Complaints-To: abuse@demon.net
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Lines: 16

Try:

CURSOR c1(p_in) IS
  SELECT *
    FROM tab1
   WHERE col1 LIKE p_in||'%';


--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk