Why IN operator in this way is not working? [message #439616] |
Mon, 18 January 2010 12:36  |
szefoski
Messages: 1 Registered: January 2010
|
Junior Member |
|
|
Hi!
I wanna do something like this:
CREATE OR REPLACE PROCEDURE T1 (var varchar2)
IS
BEGIN
IF var NOT IN table.column THEN -- column is varchar2
RAISE_APPLICATION_ERROR(-20205,'foo');
END IF;
END T1;
Why this is not working? And when I change table.column to (SELECT column FROM table) is stil not working. How to fix this?
[Updated on: Mon, 18 January 2010 12:44] Report message to a moderator
|
|
|
|
|
|