APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Successful APEX_EXEC.EXECUTE_WEB_SOURCE call leads to weird ORA-06502: PL/SQL: numeric or value erro

Denis SavenkoNov 9 2018 — edited Feb 14 2019

I have an application where there is a defined Web Source with defined GET, POST, PATCH and DELETE operations.

GET works perfectly fine and my interactive report is based on top of it.

But I have a weird issue with the POST, PATCH and DELETE operations.

The thing is that I have a very simple package with procedures utilizing APEX_EXEC.EXECUTE_WEB_SOURCE API.

For example, here is what I have for the POST operation:

procedure add_department(

p_name varchar2,

p_location varchar2,

p_country varchar2

) is

-- parameters collection variable

l_parameters apex_exec.t_parameters;

begin

-- prepare the parameters for the Web Service operation

apex_exec.add_parameter(p_parameters => l_parameters, p_name => 'NAME', p_value => p_name);

apex_exec.add_parameter(p_parameters => l_parameters, p_name => 'LOCATION', p_value => p_location);

apex_exec.add_parameter(p_parameters => l_parameters, p_name => 'COUNTRY', p_value => p_country);

-- invoke POST operation, defined in the Web Service definition

apex_exec.execute_web_source(

  p\_module\_static\_id => 'ALIEN\_DEPARTMENTS',

  p\_operation        => 'POST',

  p\_parameters       => l\_parameters

);

end add_department;

Then I have a button which invokes this procedure.

And everything works fine, since on the other side I see the correct query and it succeds (here is my ngrep output):

T 192.168.88.30:30525 -> 192.168.88.31:8000 [AP] #406

POST /departments HTTP/1.1..Host: 192.168.88.31:8000..Proxy-Connection: Keep-Alive..Content-Length: 52..Content-Type: application/json; charset=utf-8..Prefer: return=minimal..User-Agent: Oracle Application Express..Connection: close....

T 192.168.88.30:30525 -> 192.168.88.31:8000 [AP] #408

{"name":"IT", "location":"Omsk", "country":"Russia"}

T 192.168.88.31:8000 -> 192.168.88.30:30525 [AP] #410

HTTP/1.1 201 Created..Transfer-Encoding: chunked..Date: Thu, 08 Nov 2018 06:12:51 GMT..Server: postgrest/5.1.0 (UNKNOWN)..Content-Range: */*....0....

But because of some reason, I every time get a weird ORA-06502: PL/SQL: numeric or value error with this all (so, the query is succesful, but I get the exception):

Here is what I have in APEX debug console at the time:

"Elapsed","Execution","Message","Level"

"0.00109","0.00161","Reset NLS settings","4"

"0.00270","0.00028","alter session set NLS_COMP='BINARY' NLS_SORT='BINARY' NLS_CALENDAR='GREGORIAN' NLS_TERRITORY='AMERICA' NLS_LANGUAGE='AMERICAN'","4"

"0.00297","0.00002","...NLS: Set Decimal separator="".""","4"

"0.00300","0.00027","...NLS: Set NLS Group separator="",""","4"

"0.00327","0.00004","...NLS: Set g_nls_date_format=""DD-MON-RR""","4"

"0.00331","0.00005","...NLS: Set g_nls_timestamp_format=""DD-MON-RR HH.MI.SSXFF AM""","4"

"0.00336","0.00224","...NLS: Set g_nls_timestamp_tz_format=""DD-MON-RR HH.MI.SSXFF AM TZR""","4"

"0.00560","0.00007","...Setting session time_zone to +06:00","4"

"0.00568","0.00041","R E Q U E S T accept P201_ADD_DEPARTMENT","4"

"0.00609","0.00091","Metadata: Fetch application definition and shortcuts","4"

"0.00700","0.00037","NLS: wwv_flow.g_flow_language_derived_from=FLOW_PRIMARY_LANGUAGE: wwv_flow.g_browser_language=en","4"

"0.00738","0.00003","alter session set nls_language='AMERICAN' nls_territory='AMERICA'","4"

"0.00741","0.00009","NLS: CSV charset=WE8MSWIN1252","4"

"0.00749","0.00002","...NLS: Set Decimal separator="".""","4"

"0.00752","0.00009","...NLS: Set NLS Group separator="",""","4"

"0.00761","0.00003","...NLS: Set g_nls_date_format=""DD-MON-RR""","4"

"0.00764","0.00003","...NLS: Set g_nls_timestamp_format=""DD-MON-RR HH.MI.SSXFF AM""","4"

"0.00767","0.00004","...NLS: Set g_nls_timestamp_tz_format=""DD-MON-RR HH.MI.SSXFF AM TZR""","4"

"0.00771","0.00057","...metadata, fetch translated app info","4"

"0.00828","0.00032","Authentication check: Application Express Authentication (NATIVE_APEX_ACCOUNTS)","4"

"0.00860","0.00031","Session State: fetch from database (exact)","4"

"0.00891","0.00006","... sentry+verification success","4"

"0.00896","0.00037","...Session ID 11991962176351 can be used","4"

"0.00933","0.00007","...Setting session time_zone to +06:00","4"

"0.00940","0.00040","...Check for session expiration:","4"

"0.00980","0.00034","...Metadata: Fetch Page, Computation, Process, and Branch","4"

"0.01014","0.00110","...Parse JSON","4"

"0.01124","0.00029","......Validate item page affinity","4"

"0.01153","0.00011","......Read Page Item values and validate protected items","4"

"0.01164","0.00006",".........Name=P201_NAME (id=2142895947724672), value=IT, checksum=","4"

"0.01170","0.00006",".........Name=P201_LOCATION (id=2143215776724672), value=Omsk, checksum=","4"

"0.01176","0.00003",".........Name=P201_COUNTRY (id=2143626474724673), value=Russia, checksum=","4"

"0.01179","0.00003","......Check existance of all Protected Page Items=","4"

"0.01182","0.00004","...Check authorization security schemes","4"

"0.01186","0.00004","Session State: Save form items and p_arg_values","4"

"0.01190","0.00033","Session State: P201_NAME=>IT","4"

"0.01222","0.00017","Session State: P201_LOCATION=>Omsk","4"

"0.01239","0.00015","Session State: P201_COUNTRY=>Russia","4"

"0.01254","0.00036","Session State: COMMIT","4"

"0.01291","0.00008","Processes - point: ON_SUBMIT_BEFORE_COMPUTATION","4"

"0.01299","0.00005","Branches - point: BEFORE_COMPUTATION","4"

"0.01304","0.00003","Process point: AFTER_SUBMIT","4"

"0.01307","0.00017","Tabs: Perform Branching for Tab Requests","4"

"0.01324","0.00006","Branches - point: BEFORE_VALIDATION","4"

"0.01329","0.00018","Validations:","4"

"0.01347","0.00056","Perform basic and predefined validations:","4"

"0.01403","0.00023","...Validate is not null for P201_NAME","4"

"0.01427","0.00022","...Validate is not null for P201_LOCATION","4"

"0.01448","0.00028","...Validate is not null for P201_COUNTRY","4"

"0.01476","0.00019","Perform custom validations:","4"

"0.01495","0.00004","Branches - point: BEFORE_PROCESSING","4"

"0.01499","0.00004","Processes - point: AFTER_SUBMIT","4"

"0.01503","0.00219","...Process ""Save Department"" - Type: NATIVE_PLSQL","4"

"0.01722","0.00005","processing 5 parameters","4"

"0.01727","0.00003","default value for parameter (1) ""COUNTRY"" is """"","4"

"0.01730","0.00004","computed component value for parameter ""COUNTRY"": ""Russia"".","4"

"0.01734","0.00003","default value for parameter (2) ""Content-Type"" is ""application/json; charset=utf-8""","4"

"0.01736","0.00003","value for parameter ""Content-Type"" is static.","4"

"0.01740","0.00003","default value for parameter (3) ""LOCATION"" is """"","4"

"0.01742","0.00003","computed component value for parameter ""LOCATION"": ""Omsk"".","4"

"0.01746","0.00003","default value for parameter (4) ""NAME"" is """"","4"

"0.01749","0.00004","computed component value for parameter ""NAME"": ""IT"".","4"

"0.01752","0.00002","default value for parameter (5) ""Prefer"" is ""return=minimal""","4"

"0.01754","0.00008","value for parameter ""Prefer"" is static.","4"

"0.01762","0.00005","URL built is complete: returning ""http://192.168.88.31:8000/departments""","4"

"0.01767","0.00004","setting HTTP request header #1: ""Content-Type""=""application/json; charset=utf-8"".","4"

"0.01771","0.00003","setting HTTP request header #2: ""Prefer""=""return=minimal"".","4"

"0.01774","0.00004","setting request header #3: ""User-Agent""=""Oracle Application Express"".","4"

"0.01777","0.00099","Building the request body from the request body template.","4"

"0.01876","0.00003","Request body is: {""name"":""IT"", ""location"":""Omsk"", ""country"":""Russia""}","4"

"0.01879","0.01270","Making POST request to http://192.168.88.31:8000/departments","4"

"0.03149","0.00083","Exception in ""Save Department"":

Error Stack: ORA-06502: PL/SQL: numeric or value error

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2329

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8143

ORA-06512: at ""SYS.UTL_RAW"", line 380

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8102

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 1587

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC_HTTP"", line 134

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2319

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2347

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC"", line 2213

Backtrace: ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2329

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8143

ORA-06512: at ""SYS.UTL_RAW"", line 380

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8102

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 1587

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC_HTTP"", line 134

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2319

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2347

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC"", line 2213

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_API"", line 1300

","2"

"0.03232","0.00032","Exception in ""plsql process"":

Error Stack: ORA-06502: PL/SQL: numeric or value error

ORA-06512: at ""APEX_180200.WWV_FLOW_DYNAMIC_EXEC"", line 1476

ORA-06512: at ""APEX_180200.WWV_FLOW_DYNAMIC_EXEC"", line 2465

ORA-06512: at ""APEX_APPS.ALIEN_DATA_MANAGEMENT"", line 26

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_API"", line 1314

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2329

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8143

ORA-06512: at ""SYS.UTL_RAW"", line 380

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8102

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 1587

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC_HTTP"", line 134

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2319

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2347

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC"", line 2213

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_API"", line 1300

ORA-06512: at ""APEX_APPS.ALIEN_DATA_MANAGEMENT"", line 20

ORA-06512: at line 1

ORA-06512: at ""SYS.DBMS_SQL"", line 1721

ORA-06512: at ""APEX_180200.WWV~

Backtrace: ORA-06512: at ""APEX_APPS.ALIEN_DATA_MANAGEMENT"", line 26

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_API"", line 1314

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2329

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8143

ORA-06512: at ""SYS.UTL_RAW"", line 380

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8102

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 1587

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC_HTTP"", line 134

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2319

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2347

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC"", line 2213

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_API"", line 1300

ORA-06512: at ""APEX_APPS.ALIEN_DATA_MANAGEMENT"", line 20

ORA-06512: at line 1

ORA-06512: at ""SYS.DBMS_SQL"", line 1721

ORA-06512: at ""APEX_180200.WWV_FLOW_DYNAMIC_EXEC"", line 2450

ORA-06512: at ""APEX_180200.WWV_FLOW_DYNAMIC_EXEC"", line 1476

ORA-06512: at ""APEX_180200.WWV_FLOW_DYNAMIC_EXEC"", line 2465

ORA-06512: at ""APEX_APPS.ALIEN_DATA_MANAGEMENT"", line 26

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_API"", line 1314

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2329

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8143

ORA-06512: at ""SYS.UTL_RAW"", line 380

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8102

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 1587

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC_HTTP"", line 134

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2319

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2347

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC"", line 2213

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_API"", line 1300

ORA-06512: at ""APEX_APPS.ALIEN_DATA_MANAGEMENT"", line 20

ORA-06512: at line 1

ORA-06512: at ""SYS.DBMS_SQL"", line 1721

ORA-06512: at ""APEX_180200.WWV_FLOW_DYNAMIC_EXEC"", line 2450

ORA-06512: ~","2"

"0.03264","0.00008","Exception in ""Save Department"":

Error Stack: ORA-06502: PL/SQL: numeric or value error

ORA-06512: at ""APEX_180200.WWV_FLOW_PROCESS_NATIVE"", line 92

ORA-06512: at ""APEX_180200.WWV_FLOW_DYNAMIC_EXEC"", line 1476

ORA-06512: at ""APEX_180200.WWV_FLOW_DYNAMIC_EXEC"", line 2465

ORA-06512: at ""APEX_APPS.ALIEN_DATA_MANAGEMENT"", line 26

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_API"", line 1314

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2329

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8143

ORA-06512: at ""SYS.UTL_RAW"", line 380

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8102

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 1587

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC_HTTP"", line 134

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2319

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2347

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC"", line 2213

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_API"", line 1300

ORA-06512: at ""APEX_APPS.ALIEN_DATA_MANAGEMENT"", line 20

ORA-06512: at line 1

ORA-06512~

Backtrace: ORA-06512: at ""APEX_APPS.ALIEN_DATA_MANAGEMENT"", line 26

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_API"", line 1314

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2329

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8143

ORA-06512: at ""SYS.UTL_RAW"", line 380

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8102

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 1587

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC_HTTP"", line 134

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2319

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2347

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC"", line 2213

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_API"", line 1300

ORA-06512: at ""APEX_APPS.ALIEN_DATA_MANAGEMENT"", line 20

ORA-06512: at line 1

ORA-06512: at ""SYS.DBMS_SQL"", line 1721

ORA-06512: at ""APEX_180200.WWV_FLOW_DYNAMIC_EXEC"", line 2450

ORA-06512: at ""APEX_180200.WWV_FLOW_PROCESS_NATIVE"", line 92

ORA-06512: at ""APEX_180200.WWV_FLOW_DYNAMIC_EXEC"", line 1476

ORA-06512: at ""APEX_180200.WWV_FLOW_DYNAMIC_EXEC"", line 2465

ORA-06512: at ""APEX_APPS.ALIEN_DATA_MANAGEMENT"", line 26

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_API"", line 1314

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2329

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8143

ORA-06512: at ""SYS.UTL_RAW"", line 380

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8102

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 1587

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC_HTTP"", line 134

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2319

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2347

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC"", line 2213

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_API"", line 1300

ORA-06512: at ""APEX_APPS.ALIEN_DATA_MANAGEMENT"", line 20

ORA-06512: at line 1

ORA-06512: at ""SYS.DBMS_SQL"", line 1721

ORA-06512: ~","2"

"0.03272","0.00089","Add error onto error stack","4"

"0.03361","0.00385","Hiding error additional_info, as it contains ORA error message: ORA-06502: PL/SQL: numeric or value error","1"

"0.03745","0.00006","Error: ORA-06502: PL/SQL: numeric or value error","1"

"0.03751","0.00004","- additional_info: ORA-06502: PL/SQL: numeric or value error","4"

"0.03755","0.00004","- display_location: INLINE_IN_NOTIFICATION","4"

"0.03760","0.00004","- is_internal_error: false","4"

"0.03764","0.00005","- ora_sqlcode: -6502","4"

"0.03769","0.00005","- ora_sqlerrm: ORA-06502: PL/SQL: numeric or value error

ORA-06512: at ""APEX_180200.WWV_FLOW_PROCESS_NATIVE"", line 92

ORA-06512: at ""APEX_180200.WWV_FLOW_DYNAMIC_EXEC"", line 1476

ORA-06512: at ""APEX_180200.WWV_FLOW_DYNAMIC_EXEC"", line 2465

ORA-06512: at ""APEX_APPS.ALIEN_DATA_MANAGEMENT"", line 26

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_API"", line 1314

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2329

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8143

ORA-06512: at ""SYS.UTL_RAW"", line 380

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8102

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 1587

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC_HTTP"", line 134

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2319

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2347

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC"", line 2213

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_API"", line 1300

ORA-06512: at ""APEX_APPS.ALIEN_DATA_MANAGEMENT"", line 20

ORA-06512: at line 1

ORA-06512~","4"

"0.03774","0.00004","- error_backtrace: ORA-06512: at ""APEX_APPS.ALIEN_DATA_MANAGEMENT"", line 26

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_API"", line 1314

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2329

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8143

ORA-06512: at ""SYS.UTL_RAW"", line 380

ORA-06512: at ""APEX_180200.WWV_FLOW_UTILITIES"", line 8102

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 1587

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC_HTTP"", line 134

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2319

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_WEB_SRC"", line 2347

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC"", line 2213

ORA-06512: at ""APEX_180200.WWV_FLOW_EXEC_API"", line 1300

ORA-06512: at ""APEX_APPS.ALIEN_DATA_MANAGEMENT"", line 20

ORA-06512: at line 1

ORA-06512: at ""SYS.DBMS_SQL"", line 1721

ORA-06512: at ""APEX_180200.WWV_FLOW_DYNAMIC_EXEC"", line 2450

ORA-06512: at ""APEX_180200.WWV_FLOW_PROCESS_NATIVE"", line 92

ORA-06512: at ""APEX_180200.WWV_FLOW_DYNAMIC_EXEC"", line 1476

ORA-06512: ~","4"

"0.03778","0.00004","- error_statement: begin alien_data_management.add_department(

p_name => :P201_NAME,

p_location => :P201_LOCATION,

p_country => :P201_COUNTRY

);

end;","4"

"0.03782","0.00035","- component: APEX_APPLICATION_PAGE_PROCESS Save Department (2144029097724703)","4"

"0.03817","0.00006","...Inline Errors detected, performing rollback","4"

"0.03823","-","Emit errors as JSON","4"

So, as you can see, the error occurs at the line 2329 of the APEX_180200.WWV_FLOW_EXEC_WEB_SRC package, which is not quite accessible by us.

Situation is exactly the same with PATCH and DELETE operations.

At the moment, I use a workaround by just suppressing this error and everything works after this.

But it looks like a real bug.

Or is there anything I'm doing wrong? @"Carsten Czarski-Oracle", could you please comment on all this. Thank you very much in advance!

This post has been answered by Carsten Czarski-Oracle on Nov 12 2018

Jump to Answer

Added on Nov 9 2018

#apex-discussions

19 comments

2,657 views

APEX

Successful APEX_EXEC.EXECUTE_WEB_SOURCE call leads to weird ORA-06502: PL/SQL: numeric or value erro

Comments

Post Details