Use dbms_sql.bind_variable to bind variable
SQL>
SQL> create table myTable( pid primary key )
2 organization index
3 as select rownum from all_objects
4 where rownum <=0;
Table created.
SQL>
SQL>
SQL>
SQL>
SQL>
SQL>
SQL> create or replace procedure binding is
2 cursorValue number;
3
4 returnValue number;
5 returnValue1 number;
6 begin
7 cursorValue := dbms_sql.open_cursor;
8 dbms_sql.parse(cursorValue, 'select pid from myTable '|| 'where pid = :b1', dbms_sql.native);
9 for i in 1 ..0 loop
10 dbms_sql.bind_variable(cursorValue,':b1',i);
11 returnValue := dbms_sql.execute(cursorValue);
12 returnValue1 := dbms_sql.fetch_rows(cursorValue);
13 end loop;
14 dbms_sql.close_cursor(cursorValue);
15 end;
16 /
Procedure created.
SQL>
SQL> show errors
No errors.
SQL>
SQL> drop table myTable;
Table dropped.
SQL>
SQL>
SQL>
Related examples in the same category