Stored SQL Procedures can be executed via SELECT statement:
SELECT PROCEDURE_NAME (parameter , parameter...);
For ex.:
create procedure mytest ( in ss varchar) { return concat('My simple test with ', ss); } ; SQL> select mytest('Virtuoso'); callret VARCHAR _______________________________________________________________________________ My simple test with Virtuoso 1 Rows. -- 0 msec.
Previous
Virtuoso/PL Syntax |
Chapter Contents |
Next
Execute Stored Procedures In Background |