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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!