Executing the following statement in Oracle Toad
exec plsql_procedure(select 'somestring' from dual);
trhows the following exception:
ORA-06550: line 1, column 33:
PLS-00103: Encountered the symbol "SELECT" when expecting one of the following:
( ) – + case mod new not null
Procedure takes one VARCHAR2 parameter. How it can be fixed?