We are learning oracle 8i form builder. We have tables named products, suppliers and shopping_chart.
We have a form which shows one supplier at the time and all of itīs products.
We have button after every product which inserts that product to the shopping_chart table.
In the suppliers table we have supplier_id as a primary key and supplier_name,
in the products table we have product_id as a primary key, product_name, price and supplier_id as a foreign key.
In the shopping_chart table we have chart_id as a primary key, supplier_id and product_id as foreign keys.
Now we are trying to do a form which shows the products and suppliers that are in the shopping_chart table.
We have functions GetProduct, GetPrice and GetSupplier. Product_name and price shows well,
but we canīt get suppliers name to show.
GetSupplier function looks like this
pSupplier_id in suppliers.supplier_id%type)
RETURN varchar2 IS
select supplier_name into name from suppliers, products
where pSupplier_id=suppliers.supplier_id and
exception when no_data_found then null;
When we run the form it says FRM-40735:FORMULA CALCULATION trigger raised unhandled exception ORA-06503.
After this there comes one product at the time visible to the shopping_chart form if we push the next record button.
These might be very silly questions, but we canīt get anywhere with this so we are very greatful if somebody could help us.
Thanks a lot.