I tried that too, it doesn't allow me to use the parameter without &

Hello Brajesh, Yes, it does look like the SQL formatting is incorrect. Is there a way to see the SQL's it construct in the log or some place else? The bipublisher logs I'm looking in weblogic EM just shows the invalid relational operator error nothing else. As far as the variables it is defined in package spec. Also I have…

Can anyone shed some light on what I'm missing here, I would greatly appreciate. Thanks,

Yes both the parameters are defined as in the pl/sql package as public variables. Here is the code snippet, P_COND_SERVICE_PROVIDER_PARAM VARCHAR2(1000); P_COND_SOURCE_LOCATION_PARAM VARCHAR2(1000); IF P_SERVICE_PROVIDER IS NOT NULL THEN P_COND_SERVICE_PROVIDER_PARAM := ' Service_Provider_Location.LOCATION_GID' || '' ||…