U0100072: GaussDB does not support JSON_VALUE

Description

Database Type and Version

Source database type and version: Oracle versions supported by UGO
Target database type and version: GaussDB versions supported by UGO

Syntax Example

On an Oracle database, JSON_VALUE finds a specified scalar value (such as a string, number, or Boolean value) in JSON documents.

JSON_EXTRACT_PATH_TEXT of GaussDB is similar to JSON_VALUE of Oracle. However, their query paths are different. In the following query scenarios, UGO cannot automatically convert the function, so you need to modify the query path:

A relative path is used.
Wildcards are used, for example, $.a.*.b.
The query result is empty, and an error is returned.

Suggestion

Use JSON_EXTRACT_PATH_TEXT and modify the JSON data query path.

Parent topic: Error Codes Generated During Conversion from Oracle to GaussDB

Previous topic: U0100071: Dynamic SQL statements cannot be automatically converted

Next topic: U0100073: GaussDB does not have a function equivalent to SYS_OP_MAP_NONNULL

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot