COPY function not passing variable to datablock [message #657757] |
Mon, 21 November 2016 19:26 |
|
a.harinath@gmail.com
Messages: 6 Registered: September 2016
|
Junior Member |
|
|
Hi All,
I have a strange issue in using the COPY function to pass the date parameter to a datablock.
Attached code is present in the PRE-QUERY trigger in a datablock POS_SEARCH_RESULTS. The form takes the store_no, from_date, to_date, fixed, occasion_id as input parameter. The parameters are passed to another datablock POS_SEARCH_RESULTS which need to query a database table gb_pos_exceptions.
Whenever I pass the from_date in the form, for some reason it never fetch any records and getting "Query Caused No Records To Be Retrieved" error. If I comment the code with respect to the from_date and to_date in attached, then the other parameters are working fine.
Please suggest if there are alternate ways to copy the parameter values to a data block. I tried set_block_property with default_where, still no records error.
Thanks & Regards,
Harinath
|
|
|
|
|
Re: COPY function not passing variable to datablock [message #657790 is a reply to message #657761] |
Tue, 22 November 2016 16:43 |
|
a.harinath@gmail.com
Messages: 6 Registered: September 2016
|
Junior Member |
|
|
I did try your approach, but not succeful either.
Whats peculiar is this same form work in a different environment with Oracle 11g as database and Oracle Report server 11.1.2.2 running on AIX.
But issue is only when I try to port the same Oracle form onto Oracle 12C database and the report server mounted on Oracle Linux Server 6.
Is there any other option to bind the from_date and to_date to a datablock process_date (database table column)? I suspect issue could be in the COPY function appending 2 input parameters to 1 datablock column.
Thanks
|
|
|