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()
/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
Can i execute a stored procedure which is in SQL Server database from WP Data Access ?
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… 😉