Hello,
Oracle free 23ai on-premises
Apex 24.1.0
ORDS 24.3
I'm trying to follow the instructions from https://blog.cloudnueva.com/23ai-vector-search-in-apex.
When I try to run SQLWorkshop
select apex_web_service.make_rest_request_b
(p_url => 'https://docs.oracle.com/en/cloud/saas/subscription-management/fasim/implementing-subscription-management.pdf',
p_http_method => 'GET') from dual;
I get an error
Error report -
SQL Error: ORA-01841: (full) year must be between -4713 and +9999, and not be 0
ORA-06512: at "APEX_240100.WWV_FLOW_WEB_SERVICES", line 782
ORA-06512: at "APEX_240100.WWV_FLOW_WEB_SERVICES_INVOKER", line 982
ORA-06512: at "SYS.UTL_HTTP", line 945
ORA-06512: at "SYS.UTL_HTTP", line 1443
ORA-06512: at "APEX_240100.WWV_FLOW_WEB_SERVICES_INVOKER", line 256
ORA-06512: at "APEX_240100.WWV_FLOW_WEB_SERVICES_INVOKER", line 972
ORA-06512: at "APEX_240100.WWV_FLOW_WEB_SERVICES_INVOKER", line 1427
ORA-06512: at "APEX_240100.WWV_FLOW_WEB_SERVICES", line 738
ORA-06512: at "APEX_240100.WWV_FLOW_WEBSERVICES_API", line 705
ORA-06512: at line 1
01841. 00000 - "(full) year must be between -4713 and +9999, and not be 0"
The first call goes through without any problems with sql developer, the second …. error, any idea where the problem is?
Thanks