i cannot use views as it doesn't provide any placehold to subtitute
args passed from commandline.
copy/paste will work, not a good idea when many people use.

i am looking for some way simillar to,
call query1 <arg1> <arg2>
or
eval query1 <arg1> <arg2>

can i return a query values from procedures?

say for example, if i want to return the output of this query (select
c1,c2 from t1 where c1 = "str1") from a procedure, how to do it?

pseudo code or any idea welcome

thanks
Sasi