The non-Oracle system can support OUT
bind variables. With OUT
bind variables, the value of the bind variable is not known until after the execution of the SQL statement.
Although OUT
bind variables are populated after executing the SQL statement, the non-Oracle system must know that the particular bind variable is an OUT
bind variable before the SQL statement is executed. You must use the BIND_OUT_VARIABLE
procedure to specify that the bind variable is an OUT
bind variable.
After executing the SQL statement, you can retrieve the value of the OUT
bind variable using the GET_VALUE
procedure.