Stored Procedures

You can use the SQL Query Builder to write stored procedures, functions, and triggers, provided you have the necessary credentials. Write / on an empty line after each command, as shown in the example below.

📌 If you are ISP hosted, your privileges will be limited.

✨ Example

drop procedure if exists RESULSET
/
create procedure RESULSET()
begin
  select * from dept;
end
/
call RESULSET()
/

📌 Responses

If the dept table is available in the selected database, the code above will display three responses:

• Result of the drop procedure command.
• Result of the create procedure command.
• Result of the procedure call.