I have a stored procedure that I would like to execute by using either
a single date or 2 dates and am having s problem getting the syntax correct, maybe its not even possible...??
Calling the script like so.. not even sure if this is the correct syntax for executing the procedure..
PROCEDURE PRODUCT_ORDER_DATA (p_ORDERDATE IN DATE DEFAULT NULL, p_ORDERDATE_BEG IN DATE DEFAULT NULL, p_ORDERDATE_END IN DATE DEFAULT NULL) AS
IF p_ORDERDATE_BEG IS NULL AND p_ORDERDATE_END IS NULL THEN
... execute a single day script
... execute a BETWEEN script
So I was trying to use the above and wondered if this was the best way to approch the problem?
Looking for some suggestions or better ideas..