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, [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
