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?

This happens when querying a UTF8 database on a non-UTF8 Oracle client. The QBE data can now only be passed as bind variable data, since the SQL text cannot include UTF8 characters.

To resolve this you can change the client character set to UTF8 by setting NLS_LANG to <LANGUAGE>_<TERRITORY>.UTF8

Thanks Marco,

Unfortunately I cannot switch between NLS_LANG settings that easy but it wil do for me now.

You can start PLD instance with required NLS by setting NLS_LANG parameter in the shortcut.