Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
declare
  stmt varchar2(4000);
  sortby varchar2(30) := 'table_name';
  sortorder varchar2(4) := 'desc';
  startindex pls_integer := 1;
  pagesize pls_integer := 10;
  curs sys_refcursor;
  name all_tables.table_name%type;
begin
  stmt := 'SELECT table_name FROM all_tables ORDER BY :sortby :sortoder OFFSET :startindex ROWS FETCH NEXT :pagesize ROWS ONLY';

  open curs for stmt using sortby, sortorder, startindex, pagesize;
  loop
    fetch curs into name;
    exit when curs%notfound;
    dbms_output.put_line(name);
  end loop;
end;
/
ORA-01006: Bind variable does not exist.
ORA-06512: at line 12

declare
  stmt varchar2(4000);
  sortby varchar2(30) := 'table_name';
  sortorder varchar2(4) := 'desc';
  startindex pls_integer := 1;
  pagesize pls_integer := 10;
  curs sys_refcursor;
  name all_tables.table_name%type;
begin
  stmt := 'SELECT table_name FROM all_tables ORDER BY :sortorder desc OFFSET :startindex ROWS FETCH NEXT :pagesize ROWS ONLY';

  open curs for stmt using sortby, startindex, pagesize;
  loop
    fetch curs into name;
    exit when curs%notfound;
    dbms_output.put_line(name);
  end loop;
end;
/
1 rows affected

dbms_output:
SYSTEM_PRIVILEGE_MAP
TABLE_PRIVILEGE_MAP
USER_PRIVILEGE_MAP
STMT_AUDIT_OPTION_MAP
XDB$IMPORT_TT_INFO
AUDIT_ACTIONS
ALL_UNIFIED_AUDIT_ACTIONS
WRR$_REPLAY_CALL_FILTER
SCHEDULER_FILEWATCHER_QT
AV_DUAL

declare
  stmt varchar2(4000);
  sortby varchar2(30) := 'table_name';
  sortorder varchar2(4) := 'desc';
  startindex pls_integer := 1;
  pagesize pls_integer := 10;
  curs sys_refcursor;
  name all_tables.table_name%type;
begin
  stmt := 'SELECT table_name FROM all_tables ORDER BY '
    || sortby || ' ' || sortorder || ' OFFSET :startindex ROWS FETCH NEXT :pagesize ROWS ONLY';

  open curs for stmt using startindex, pagesize;
  loop
    fetch curs into name;
    exit when curs%notfound;
    dbms_output.put_line(name);
  end loop;
end;
/
1 rows affected

dbms_output:
XDB_INDEX_DDL_CACHE
XDB$XIDX_IMP_T
XDB$IMPORT_TT_INFO
XDB$IMPORT_QN_INFO
XDB$IMPORT_PT_INFO
XDB$IMPORT_NM_INFO
WRR$_REPLAY_CALL_FILTER
WRI$_HEATMAP_TOPN_DEP2
WRI$_HEATMAP_TOPN_DEP1
WRI$_ADV_ASA_RECO_DATA