¶
11.8. Execute Stored Procedures via SELECT statement
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.