sql - How to use DBMS_SQL with multiple bind_variables

Question

I don't have a code example that I want to solve, I am just asking because I might run into this problem during a test. I know how to use DBMS_SQL to execute a dynamic query with a single bind variable (the example below), what do I do when I have more bind variables?

CREATE OR REPLACE PROCEDURE demo(salary IN NUMBER) AS
    cursor_name INTEGER;
    rows_processed INTEGER;
BEGIN
    cursor_name := dbms_sql.open_cursor;
    DBMS_SQL.PARSE(cursor_name, 'DELETE FROM emp WHERE sal > :x',
                   DBMS_SQL.NATIVE);
    DBMS_SQL.BIND_VARIABLE(cursor_name, ':x', salary);
    rows_processed := DBMS_SQL.EXECUTE(cursor_name);
    DBMS_SQL.CLOSE_CURSOR(cursor_name);
EXCEPTION
WHEN OTHERS THEN
    DBMS_SQL.CLOSE_CURSOR(cursor_name);
END;

question from:https://stackoverflow.com/questions/65598562/how-to-use-dbms-sql-with-multiple-bind-variables

Answer 1

Waitting for answers