Query by example shows :qbe_var1 in stead of value by Oracle 19c - 12/03/19 08:09 AM
Using PL/SQL Dev 13.0.6 / Oracle 12.2 oci.dll
When doing a "query by example" on Oracle 12c the query is build as expected.
select * from MDR_ODE_EMAIL t
where ode_id = 'VN'
When doing the same "query by example" on Oracle 19c the query is showing :qbe_var1 in stead of 'VN'
select * from MDR_ODE_EMAIL t
where ode_id = :qbe_var1
Bug or configuration problem?
When doing a "query by example" on Oracle 12c the query is build as expected.
select * from MDR_ODE_EMAIL t
where ode_id = 'VN'
When doing the same "query by example" on Oracle 19c the query is showing :qbe_var1 in stead of 'VN'
select * from MDR_ODE_EMAIL t
where ode_id = :qbe_var1
Bug or configuration problem?