Question: SQL Hey Trying to make a procedure calling two functions but I know the syntax is incorrect, but dont know where, please help. Best case
SQL Hey
Trying to make a procedure calling two functions but I know the syntax is incorrect, but dont know where, please help.
Best case scenario you would see my tables and functions but maybe you can just get a overhead look and work it out.
Create or replace procedure do_gymbesk( P_rfid in gymbesk.rfid%type, P_gymid in number) As Begin Insert into gymbesk (radnr,rfid,gymid,datum) Values (radnr.seq_nextval, p_rfid, p_gymid, sysdate); if (get_behrighet (p_gymid, p_rfid) = 0) then raise_application_error (-20001, 'behrig'); or (get_trningspass(p_antal) = 0) then raise_application_error (-20001, 'Inga trningspass kvar');
end if; end; /
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
