Re: In Stored Procedure, how to check if variable is NULL?
Posted by:
neilc
Date: August 22, 2005 03:18PM
OK thanks for the adivice, but still how do I simulate testing for NULL, as in:
IF Number IS NULL
BEGIN
SET Number = 0;
END IF;
This does not work, syntax error. Though it does work in MSSQL.
Thanks in advance.
Subject
Written By
Posted
Re: In Stored Procedure, how to check if variable is NULL?
August 22, 2005 03:18PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.