Search notes:

Oracle: DBMS_SQL.BIND_VARIABLE

dbms_sql.bind_variable associates a bind variable with a value with which an SQL statement will be executed.
declare
   value  … := …;
begin

   …

   dbms_sql.bind_variable(cur, ':var', value);
   …
end;
/

See also

dbms_sql

Index