Originally posted by gandolf989
Bind variables are good for DML type commands
...
mystr := 'UPDATE mytable SET col1 = :1 WHERE col1 = :2';
EXECUTE IMMEDIATE mystr USING 'A', 'B';
...
But the SELECT INTO command that you specify is not going to improve by the use of bind variables.
The "bind varibles are good" mantra is totaly equaly applicable to DMLs as it is to selects! Absolutely no difference! None!
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?