Passing parameters via ampersand sign

Passing parameters via ampersand sign

Postby alex100 » Fri 03 Feb 2017 10:06


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 :

Posts: 6
Joined: Mon 18 Jul 2016 19:56

Re: Passing parameters via ampersand sign

Postby Pinturiccio » Tue 07 Feb 2017 14:39

We will consider the possibility to support parameters with the & prefix in the Direct mode, but there is no timeframe.
Devart Team
Posts: 2060
Joined: Wed 02 Nov 2011 09:44

Return to dotConnect for Oracle