Stored procedures

Table of Contents

Example

Write / on an empty line to enter a stored procedure, stored function, or database trigger.

Example #

drop procedure if exists DEPT
/

create procedure DEPT()
begin
  select * from dept;
end
/

call DEPT()
/

Presuming table dept is available in the selected database, the code above will show three tabs:

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

WP Data Access - Query Builder - Stored Procedures

Still stuck? How can we help?

Updated on 2022-12-04

2 Comments

Marcos Marilaf on 2023-01-27 at 3:59 pm

Can i execute a stored procedure which is in SQL Server database from WP Data Access ?
Reply
- Peter Schulz on 2023-01-29 at 10:35 am
  
  Sorry Markos, that’s not possible. You should be able to use stored procedures in your database triggers, but I’m not sure how custom errors are passed. Never tried myself. But I would be greatful if you can share valuable information… 😉
  Reply

Submit a Comment Cancel reply