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.