I came back with my last question. The view could be created now but without parameters sent as procedure arguments.
I would have liked to see running something like (it's just a simplified form):
CREATE OR REPLACE PROCEDURE sql_test (emp_name) AS
'create or replace view ACTIVES as select * from salary
where emp like :e_name||''%'' '
USING emp_name ;
when others then
But it seems do not be accepted something like :e_name in the create view.
The error message is
ORA-01027: bind variables not allowed for data definition operations
Have you found a way to avoid this error message and to send the parameter for creating the view in this way?
Thank you very much,