sql>create or replace procedure myproc(p_value  in  varchar2)
  2  is 
  3  begin 
  4    dbms_output.put_line( 'Value: ' || p_value ); 
  5  end;
  6  /
 
Procedure created.
 
sql>declare 
  2    sqlstr  varchar2(100); 
  3    cid     pls_integer;
  4    r       pls_integer; 
  5  begin 
  6    cid := dbms_sql.open_cursor; 
  7    sqlstr := 'begin myproc(:v); end;'; 
  8    dbms_sql.parse(cid, sqlstr, dbms_sql.v7); 
  9    dbms_sql.bind_variable_char(cid, 'v', 'Hello World!');
 10    r := dbms_sql.execute(cid); 
 11    dbms_sql.close_cursor(cid); 
 12  end; 
 13  /
 
Value: Hello World!
 
PL/SQL procedure successfully completed.