I have problems when carrying out these two subprograms (in a TRATAR_VENDEDORES package):
SELLERS_ AND_ YOUR_DIRECTORS: Procedure that receives the number of a vendor and visualizes its number, name, title, and the same data of its director. Use for each data output a local procedure called SHOW_VENDE.
SUBIDA_CUOTA: Procedure that increases the quota of all vendors in office # 12 who have a quota below 200,000 in the percentage indicated to the call.
I have to include in the package, cursors and the necessary treatment for the management of possible errors. Can anybody help me?. Thank you very much for your time.
The table is called repventas and is the following ..
create table repventas (
num_empl number(3) primary key,
nombre varchar2(15),
edad number(2),
oficina_rep number(2),
titulo varchar2(10),
contrato date,
dir number(3),
cuota number(8,2),
ventas number(8,2),
foreign key (oficina_rep) references oficinas on delete cascade