& Prompts

[i257156]

I have a query which I have compiled in Query Builder.
However I am wanting to stick a prompt in and cannot get it to work.

Although QB allows me to run the report finding no errors it doesn't prompt me and it produces no results and I know that there should be.

The line in particular is

OUN_NAME = '&Org_Events.OUN_NAME'

Can anyone offer me any advice please?
Thanks
JB

 

[sem]

Why do you think that QB knows anything about "&" meaning? It treats '&Org_Events.OUN_NAME' as string literal. & is used for marking lexical parameter in sql*plus and some other tools, but not in QB. Even in sql*plus other character may be used instead of &.
Try to use only bind variables.
BTW, can you explain what this parameter means? In any case it wouldn't be evaluated, because it's quoted:

select 'sysdate' from dual returns 'sysdate' word rather than current date.


Regards, Dima