How to create a bind variable in Oracle when using SAS/ACCESS® Interface to Oracle


When you use pass-through code with SAS/ACCESS Interface to Oracle, SAS is unable to create a bind variable in Oracle. Instead, you need to create an Oracle stored procedure that creates the bind variable. Then you can use pass-through code to call the stored procedure.