Hi,
When specifying parameters in SQL and working in oci mode its perfectly possible to use both : and & symbols to specify parameters. e.g. where id=:id or id=&id both work fine.
But when working in direct mode & characters is not recognised as a valid parameter specifier.
Is there a way to pass params with & char?
It's useful as tools like pl/sql dev use & char and provide special UI for testing queries. So when copying sql in the code we don't have to change & for :
Thanks
Passing parameters via ampersand sign
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Passing parameters via ampersand sign
We will consider the possibility to support parameters with the & prefix in the Direct mode, but there is no timeframe.