I mean any extend procedure (such as CMDSHELL ) that can return any value as input in my procedure.

Once more :

CREATE PROCEDURE myproc

as

select * into tab1 from tab2

if exists(...