FORMS - FRM-40735 ERROR
642302May 30 2008 — edited Jun 11 2008Hi.
I've created a new application which provides the customer's commercial analysis. There are 3 text-items in my form where user fill them with the following: Establishment, Customer_id and the Period(in days) for the consulting.
After that the 'key-next-item' trigger calls my procedure 'update_details' in which I've put a common 'select' that'll provide the customer first sales date. Although I've faced troubles with this procedure.
The form doesn't run out correctly. It raises the FRM-40735 for the user and when it runs by debug mode raises:
'PDE-PXC002 Program unit execution aborted due to unhandled exception(1722).' Why is it? Could someone help me?
Following the Select Code:
BEGIN
SELECT MIN(sales_date)
INTO :first_sales_date
FROM sales
WHERE (esb_cod = :esb and
cust_id = :cust);
END;
Thank you,
----------------
Anderson