I tried the following code in SQL Workshop:
`
DECLARE
test INTEGER;
BEGIN
app_aputils.debug_pkg.debug_on;
app_aputils.ms_ews_util_pkg.init("xxx", "xxx", "xxx", "xxx", "xxx");
SELECT Count(*) INTO test from table(app_aputils.ms_ews_util_pkg.find_folders()) ;
DBMS_OUTPUT.PUT_LINE('Total = ' || TO_CHAR(test));
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.put_line(SUBSTR(SQLERRM, 1, 200));
END;
`
This Code works fine, when I switch of the autocommit.
With the auotcommit Option it raise the same error:
ORA-06503: PL/SQL: Function returned without value
ORA-06512: at "APP_APUTILS.FLEX_WS_API", line 399
ORA-06512: at "APP_APUTILS.MS_EWS_UTIL_PKG", line 305
ORA-06512: at "APP_APUTILS.MS_EWS_UTIL_PKG",
I have a APEX 5.0 App with an Page and place the initialization code in a before-header process. And I have a Classic Report with Query:
SELECT * table(app_aputils.ms_ews_util_pkg.find_folders())
which returns error:
"PL/SQL: Function returned without value"
I tried the following code in SQL Workshop: ` DECLARE test INTEGER; BEGIN app_aputils.debug_pkg.debug_on; app_aputils.ms_ews_util_pkg.init("xxx", "xxx", "xxx", "xxx", "xxx");
SELECT Count(*) INTO test from table(app_aputils.ms_ews_util_pkg.find_folders()) ; DBMS_OUTPUT.PUT_LINE('Total = ' || TO_CHAR(test)); EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.put_line(SUBSTR(SQLERRM, 1, 200)); END; `
This Code works fine, when I switch of the autocommit. With the auotcommit Option it raise the same error:
ORA-06503: PL/SQL: Function returned without value ORA-06512: at "APP_APUTILS.FLEX_WS_API", line 399 ORA-06512: at "APP_APUTILS.MS_EWS_UTIL_PKG", line 305 ORA-06512: at "APP_APUTILS.MS_EWS_UTIL_PKG",