hi ManavChowdary Chalasani
welcome
First of all, you want to print something out in open sql*plus or other's application
DO the following
Secondly, What do you want to do in your parameters passing?
You want to pass one parameter or three parameters?
if only one parameter, the query INCLAUSE that you want to extract the data out, it should match the value of varchar PARAM1 (''MAIN'',''TEST'',''TEST2'')
And I think that if your program can run probably :roll: , I suggest that please check the logic of the query careful
and you may find out the answer.
[ August 17, 2004: Message edited by: siu chung man ]