create or replace procedure check_data(proc_date date) RETURNS decimal(13,4) as
declare
_adder_debit decimal(13,4);
begin
_adder_debit = SCALAR('SELECT SUM(ADDER_AMOUNT) FROM DELL_CR_ADDER_COST WHERE DATE = ‘|| proc_date || ’ AND SIGN(ADDER_AMOUNT)= -1 GROUP BY LEDGER’,QUERY(ADDER_AMOUNT decimal(13,4)));
RETURN _adder_debit;
EXCEPTION
WHEN OTHERS THEN
DECLARE
tmp text = exception_message();
BEGIN
INSERT INTO DELL_CR_LOG_MSG ( LOG_DATE ,PROC_NAME,ERROR_MESSAGE) values (NOW(),‘check_data’,_adder_debit);
RETURN _adder_debit;
END;
end; //
when i am doing ECHO on this proc its giving me null data , but actually table is having data.
can you help in checking if anything is wrong in this dynamic query.