Hello There,
I have 1 master table where i store values for each month with its 1st date. like below
The P_MONTH column i'm taking in Below PL/SQL to retrieve that month P_PRODUCTION AND P_SALES values
[code]
declare
begin
select P_PRODUCTION INTO :PRODUCTION from XX_PRJ_STOCK_IKT_PROJ_MST where to_char(P_MONTH,'DD-MON-YY')=to_char(trunc(:UPLOAD_DATE,'Month'),'DD-MON-YY');
end;
[/code]
I tried multiple ways like changing to_char , to_date with different date formatting. also changed UPLOAD_DATE Format Mask in field properties but still i'm receiving below error.
Ajax call returned server error ORA-01403: no data found for Execute PL/SQL Code.
Any Help will be appreciated.