|
The following function is returning Null, any idea please ?
I have created a table in this function and insert a row in that table when
I call it, its returning Null.
Best Regards,
Luqman
CALL FUNCTION2(5000,0,10,1999,2000)
CREATE FUNCTION function2
(principal decimal(12,2),
rate decimal(5,2),
startyear int,
endyear int)
RETURNS TABLE(
DEP_YEAR INT,
Begin_WDV DECIMAL(12,2),
Rate DECIMAL(6,3),
Dep_Amount DECIMAL(12,2),
End_WDV DECIMAL(12,2))
LANGUAGE SQL MODIFIES SQL DATA
NOT DETERMINISTIC
DISALLOW PARALLEL
BEGIN
DECLARE GLOBAL TEMPORARY TABLE MyFile
(DEP_YEAR INT,
Begin_WDV DECIMAL(12,2),
Rate DECIMAL(6,3),
Dep_Amount DECIMAL(12,2),
End_WDV DECIMAL(12,2));
INSERT INTO MyFile VALUES(1234,5000,0.10,12000,13000);
RETURN SELECT * FROM MyFile;
END;
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.