"i had two parameter P_BID_STATUS_FLAG and P_BID_STATUS_FLAG" Do you have 2 parameters by same name? We can't have 2 parameters by same name(atleast not in the latest version 4.0.2). The expression seems fine though. By the way, what is your actual problem?