Passing parameters via ampersand sign
Posted: Fri 03 Feb 2017 10:06
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
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