create or replace type ttbl_number is table of number;

declare
	nums	ttbl_number:= ttbl_number();
	sSql	long:= 'begin :tbl.extend; :tbl(:tbl.last):= 44; end;';
begin
	execute immediate sSql
	  using in out nums;
end;

ORA- 06550 : line  1 , column  7 :
PLS- 00110 : bind variable 'TBL.EXTEND' not allowed in this context
ORA- 06512 : at line  5 

procedure Test_Shell
(	p_nTestID	integer
,	p_sMode		varchar2
,	p_dStrt		date
,	p_dStop		date
) is
	lngFullText	long;
	lngSqlText	long;
begin
  select sql_text
    into lngSqlText
    from test
   where test.id = p_nTestID;
  lngFullText:= 'declare ' || lngSqlText || 'begin Test( :sMode, :dStrt, :dStop, :sErrLvl, :nErrCode, :sErrName, :tblDetails); end;' ;
  execute immediate lngFullText
    using in p_sMode
    , in p_dStrt
    , in p_dStop
    , out sErrLvl
    , out nErrCodeCurr
    , out sErrName
    , out tblDetails
   ;
end;

procedure Test
( p_sMode varchar2
, p_dStrt date
, p_dStop date
, p_sErrLvl out varchar2
, p_nErrCode out number
, p_sErrName out varchar2
, p_tblDetails out ttbl_string
) is
  nCnt	int;
begin
  select count(*) into nCnt from emp;
   if nCnt <  50  then
     nErrCode:=  1 ;
     sErrLvl:= 'R';
     sErrName:= 'Low EMP count';
   end if;
   p_sErrLvl:= sErrLvl;
   p_nErrCode:= nErrCode;
   p_sErrName:= sErrName;
     -- Здесть должно быть заполнение таблицы p_tblDetails всякими сообщениями
 
end Test;

execute immediate lngFullText
  using in p_sMode
  , in p_dStrt
  , in p_dStop
  , out sErrLvl
  , out nErrCodeCurr
  , out sErrName
  , out tblDetails
;
Compilation errors for PACKAGE BODY ...:

Error: PLS- 00457 : expressions have to be of SQL types
Line:  1252 
Text: , out tblDetails

Error: PL/SQL: Statement ignored
Line:  1245 
Text: execute immediate lngFullText