Re: sql*plus

A snippet from the AskTom site:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:110612348061

Lexical February 25, 2002
Reviewer: Steve from Blackburn

Couldn't you just use a lexical parameter within your report

select * from t where x in ( &that_variable );

e.g.

Declare you user parameter as normal give it a default value lets say ('x') just
so it will compile, and then in a After parameter form trigger , just assign the
dynamic value you talked about to the lexical parameter. The only difference in
the SQL would be to use the &that_variable instead of the :that_variable.

Followup:

does not use bind variables. I despise code that does not use bind variables as
the is the best way to limit your scalability, flood your shared pool, kill your
repsonse time and fail.

Use bind variables! Received on Fri Jan 13 2006 - 11:31:59 CST