cursor parameter and SQL WHERE clause

Hi all,

I need to use a cursor paramter in SQL WHERE clause for a LIKE condition. There must be a way to do it, but I just can not fig out the syntax.

Example code:

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

The problem is at the last line, 'p_in%'. But it doesn't work. What is the right syntax to implement this? Or is it impossible to do it?

Thanks in advance.
Hans Xie Received on Wed Jun 16 1999 - 19:24:21 CDT