Re: If statement

Roland,

I'm confused about part of this statement.

> I would like to do an insert into the table errorlog if the vOWNER_NO has
> an id whichdoesnt exist in vSubOWNER_NO How should I write the if

            ^^^^^^^^^^^^^^^^^^

What exactly do you mean by "doesn't exist in". Is vSubOWNER_NO a list?

How about some example data for both variables?

Jared

On Wednesday 23 May 2001 02:05, Roland.Skoldblom_at_ica.se wrote:
> Hallo all you gurus,
>
>
> Why doesnt this if statement work?
>
> I would like to do an insert into the table errorlog if the vOWNER_NO has
> an id whichdoesnt exist in vSubOWNER_NO How should I write the if
> statement?
>
> IF vOWNER_NO <> vSUB_OWNER_NO
> THEN
> vInfo:= 'Script: make_file_se.vSUB_OWNER_NO:
> ' || vSUB_OWNER_NO;
> vsqlerrm:=SQLERRM;
> INSERT INTO ERRORLOG
> VALUES(vinfo, vsqlerrm, SYSDATE);
> COMMIT;
> END IF;
>
> Sincerely
>
>
> Roland Sköldblom

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).