Using bind variables for SQL called within Uniface via SQL proc
Author: email@example.com (James Oakley)
We have a requirement to code directly an SQL select using the SQL proc, however we cannot get this to work when we change the SQL to use bind variables.
We have tried using the 'blockdata' function to structure the SQL, but this does not work and the Oracle driver does not allow the use of semi colons in the SQL statement passed.
Has anyone managed to find a way to do this?
We are trying with trivial SQL at the moment:
exec :inst := 'A20';
select * from ins_ins where ins_code = :inst;