Passing parameters via ampersand sign

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 6
Joined: Mon 18 Jul 2016 19:56

Passing parameters via ampersand sign

Post by 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 :


Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Passing parameters via ampersand sign

Post by 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.

Post Reply