Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Statements

 

Passing several bind variables

Bind variables can be considered as parameters. You can have as many bind variables. You can use the following syntax to pass value to bind variables: execute immediate   '...:var1,:var2,:var3...' (code with bind variables) using   v_A,v_B,'Y'...(comma-separated list of values/variables)