Hi,

The external is onBase and cursors are used to validate parameters.
To debug the issue I stores all the parameters in a table before the validation begins. I then wrote an anonymous block calling the same procedure using the parameters from the table without any formatting. Everything worked fine but when the onBase system is calling the same procedure the cursors return not value.

Code Sample:
Declare
l_date date;
l_cur_msg varchar(50);
cursor cur_date is
select sysdate
from dual;

begin
open cur_date;
fetch cur_date into l_date;

if cur_date%NOTFOUND THEN
l_cur_msg := 'NOTFOUND';
else
l_cur_msg := 'FOUND';
end if;
close cur_date;
DBMS_OUTPUT.PUT_LINE('is_found: ' ||l_cur_msg);
DBMS_OUTPUT.PUT_LINE(''return value: '||l_date);
end;