BenjaminLim
IS-IT--Management
Further info.
My purpose is to pass the parameterlist to the 'where' part of the query statement. And the query is part of a cursor. Meaning:
CURSOR PP_SUMMARY IS
SELECT COM.Company_Name, PAY.Bank_Code, ... from...
where :RPTPARAM.C_Company_Retval and...
And this is then used to create an ASCII file and not to populate a detail block or group ...
Currently the where cause returns an error stating wrong type.
Could you advice as I am not able to change the paramlist as it is pass into other reports which I could not change.
And yes I use the display (i.e. message command) and the system returns 'JSH code in (30)' if 30 is selected.
Please advice. Thanks.
Regards
Benjamin
My purpose is to pass the parameterlist to the 'where' part of the query statement. And the query is part of a cursor. Meaning:
CURSOR PP_SUMMARY IS
SELECT COM.Company_Name, PAY.Bank_Code, ... from...
where :RPTPARAM.C_Company_Retval and...
And this is then used to create an ASCII file and not to populate a detail block or group ...
Currently the where cause returns an error stating wrong type.
Could you advice as I am not able to change the paramlist as it is pass into other reports which I could not change.
And yes I use the display (i.e. message command) and the system returns 'JSH code in (30)' if 30 is selected.
Please advice. Thanks.
Regards
Benjamin