Skip to Main Content

ORDS, SODA & JSON in the Database

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.

oracle 12.1.0.2.0 some time down when use json_table

khaled eldalySep 1 2020 — edited Sep 15 2020

can any one help me in

oracle 12.1.0.2.0  some time down when use json_table

as this error

* 2020-09-01 09:56:28.662

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)

[TOC00004]

----- Current SQL Statement for this session (sql_id=598gxw36648u4) -----

SELECT * FROM JSON_TABLE(:B1 FORMAT JSON, '$' COLUMNS ( AUTHORIZATION NUMBER PATH '$.authorization', ORGANIZATION_NO VARCHAR2 PATH '$.organization_no', VISIT_ID NUMBER PATH '$.visit_id', PATIENT_FILE_NO VARCHAR2 PATH '$.patientfileno', OPTH_CATEGORY_ID NUMBER PATH '$.category_id', IMAGE_DATE VARCHAR2 PATH '$.image_date', EYE_TYPE VARCHAR2 PATH '$.eye_type', IMAGE_ID NUMBER PATH '$.image_id', IMAGE_FILE_NAME VARCHAR2 PATH '$.image_file_name', RECORD_STATUS VARCHAR2 PATH '$.record_status' ))

[TOC00005]

----- PL/SQL Stack -----

----- PL/SQL Call Stack -----

  object      line  object

  handle    number  name

00000007A76ADA68      3666  package body EXSYS_API.MR_OPT_PKG

00000007A3032F10         2  anonymous block

[TOC00005-END]

[TOC00004-END]

Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x96AAE41B78] [PC:0x7FF7A48148A3, opifch2()+12403]

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\exsys\exsys\trace\exsys_ora_11696.trc  (incident=4468114):

ORA-07445: exception encountered: core dump [opifch2()+12403] [ACCESS_VIOLATION] [ADDR:0x96AAE41B78] [PC:0x7FF7A48148A3] [UNABLE_TO_READ] []

ORA-19114: XPST0003 - error during parsing the XQuery expression:

ORA-19202: Error occurred in XML processing

jznEngSer1:rowSep

Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\exsys\exsys\incident\incdir_4468114\exsys_ora_11696_i4468114.trc

------------------------------------------

* 2020-09-01 09:56:26.623

* SESSION ID:(1548.53559) 2020-09-01 09:56:26.623

* CLIENT ID:() 2020-09-01 09:56:26.623

* SERVICE NAME:(EXSYS) 2020-09-01 09:56:26.623

* MODULE NAME:(/Mr_opthalmology/pop_patient_opth_investigation) 2020-09-01 09:56:26.623

* CLIENT DRIVER:(jdbcthin : 19.3.0.0.0) 2020-09-01 09:56:26.623

* ACTION NAME:(POST) 2020-09-01 09:56:26.623

Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x96AAE41B78] [PC:0x7FF7A48148A3, opifch2()+12403]

Incident 4468114 created, dump file: D:\APP\ADMINISTRATOR\diag\rdbms\exsys\exsys\incident\incdir_4468114\exsys_ora_11696_i4468114.trc

ORA-07445: exception encountered: core dump [opifch2()+12403] [ACCESS_VIOLATION] [ADDR:0x96AAE41B78] [PC:0x7FF7A48148A3] [UNABLE_TO_READ] []

ORA-19114: XPST0003 - error during parsing the XQuery expression:

ORA-19202: Error occurred in XML processing

jznEngSer1:rowSep

------------------------------------

Comments

Post Details

Added on Sep 1 2020
2 comments
769 views