Web Question

Hi

 I wrote a cursor as follows

       p_last_name is an ARGU...

      CURSOR add_cur IS

         SELECT
           DISTINCT user_id
         FROM
            table_name
          WHERE
              (
              LOWER(lastname) LIKE  NVL(LOWER(p_last_name)||'%','%')
                  OR
               LOWER(lastname) >= LOWER(p_last_name)
               )
             ORDER BY LOWER(lastname);

and used the OPEN add_cur, ... FETCH add_cur INTO v_user_id to retrive the data and used the htp.print(v_user_id) to print as an html text and CLOSED the cursor using the CLOSE add_cur. It got compiled and when I tried to print the information into the html, I was getting an

ORA-17... ...SELECTed... error message

Could any one tell me the cause of this error? The query seems to function OK on the SQL net.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Mar 25 1998 - 00:00:00 CST