I had written a query within the sql block a simple fetch.
I had written the same logic on 2 pages(test and search). 1 which only contained the query (test) and the other which contains other logic in addition to this query logic(search).
In test, it fetches the result perfectly fine.
But in search, these are the parameters that were set after the sql was fired to the oracle database from vortex page
$ret :
QUERY: select case_url,title from t_case_detail_url where rownum<6 and case_element_id in(select case_element_id from t_Case_Detail_New where case_id='535798') ERROR: command sh returned exit code 1 - CASE_URL|TITLE/attachments/scmail/57493/case_535798_2967433_1.jpg|4thumbnail.jpg -
$ret.err :
nothing was returned here
$ret.stderr :
nothing was returned here
$err :
1
I had written the same logic on 2 pages(test and search). 1 which only contained the query (test) and the other which contains other logic in addition to this query logic(search).
In test, it fetches the result perfectly fine.
But in search, these are the parameters that were set after the sql was fired to the oracle database from vortex page
$ret :
QUERY: select case_url,title from t_case_detail_url where rownum<6 and case_element_id in(select case_element_id from t_Case_Detail_New where case_id='535798') ERROR: command sh returned exit code 1 - CASE_URL|TITLE/attachments/scmail/57493/case_535798_2967433_1.jpg|4thumbnail.jpg -
$ret.err :
nothing was returned here
$ret.stderr :
nothing was returned here
$err :
1