Check the version compatibility

Oct 13, 2025 by pinkandtrash.com 134 views

Introduction

Oracle PL/SQL is a powerful programming language used for developing stored procedures, functions, and packages in Oracle databases. However, when working with JSON data types, developers may encounter errors such as ORA-40573: Invalid use of PL/SQL JSON object type. In this article, we will discuss the error code -40573 and provide a step-by-step guide on how to resolve it.

Understanding the Error

The error code -40573, ORA-40573: Invalid use of PL/SQL JSON object type, occurs when you try to use the JSON_OBJECT_T type in a PL/SQL context. The JSON_OBJECT_T type is a built-in Oracle data type that represents a JSON object. However, when you try to use it in a PL/SQL procedure, function, or package, you may encounter this error.

Causes of the Error

There are several reasons why you may encounter the ORA-40573 error:

Incorrect usage: The JSON_OBJECT_T type is not supported in all PL/SQL contexts. You may need to use a different data type or approach to achieve your desired result.
Version compatibility: The JSON_OBJECT_T type is available in Oracle Database 12c and later versions. If you are using an earlier version, you may need to upgrade or use a different approach.
Syntax errors: Make sure that your PL/SQL code is free from syntax errors. A single syntax error can cause the entire procedure to fail.

Resolving the Error

To resolve the ORA-40573 error, follow these steps:

Step 1: Check the PL/SQL Context

Make sure that you are using the JSON_OBJECT_T type in a valid PL/SQL context. The JSON_OBJECT_T type is supported in the following contexts:

PL/SQL procedures: You can use the JSON_OBJECT_T type in a PL/SQL procedure to create a JSON object.
PL/SQL functions: You can use the JSON_OBJECT_T type in a PL/SQL function to return a JSON object.
PL/SQL packages: You can use the JSON_OBJECT_T type in a PL/SQL package to create a JSON object.

However, the JSON_OBJECT_T type is not supported in the following contexts:

SQL statements: You cannot use the JSON_OBJECT_T type in a SQL statement.
SQL functions: You cannot use the JSON_OBJECT_T type in a SQL function.

Step 2: Check the Version Compatibility

Make sure that your Oracle database version is compatible with the JSON_OBJECT_T type. The JSON_OBJECT_T type is available in Oracle Database 12c and later versions.

Step 3: Check the Syntax

Make sure that your PL/SQL code is free from syntax errors. A single syntax error can cause the entire procedure to fail.

Step 4: Use a Different Data Type

If you are using the JSON_OBJECT_T type in a context where it is not supported, consider using a different data type. For example, you can use the JSON_VALUE function to extract a JSON value from a JSON object.

Step 5: Upgrade Your Database

If you are using an earlier version of Oracle Database, consider upgrading to a version that supports the JSON_OBJECT_T type.

Example Use Case

Here is an example of how to use the JSON_OBJECT_T type in a PL/SQL procedure:

CREATE OR REPLACE PROCEDURE create_json_object
AS
  json_obj JSON_OBJECT_T;
BEGIN
  json_obj := JSON_OBJECT_T('name' => 'John', 'age' => 30);
  DBMS_OUTPUT.PUT_LINE(json_obj);
END;
/

In this example, we create a PL/SQL procedure called create_json_object that uses the JSON_OBJECT_T type to create a JSON object. The JSON object has two properties: name and age.

Conclusion

The ORA-40573 error occurs when you try to use the JSON_OBJECT_T type in a PL/SQL context where it is not supported. To resolve this error, make sure that you are using the JSON_OBJECT_T type in a valid PL/SQL context, check the version compatibility, check the syntax, use a different data type, or upgrade your database. By following these steps, you can resolve the ORA-40573 error and successfully use the JSON_OBJECT_T type in your PL/SQL code.

Additional Resources

For more information on the JSON_OBJECT_T type, see the Oracle documentation:

For more information on PL/SQL, see the Oracle documentation:

PL/SQL
PL/SQL Procedures
PL/SQL Functions
PLSQL JSON_OBJECT_T Error Code: -40573 - ORA-40573: Invalid use of PL/SQL JSON object type - Q&A ===========================================================

Introduction

In our previous article, we discussed the error code -40573, ORA-40573: Invalid use of PL/SQL JSON object type, and provided a step-by-step guide on how to resolve it. In this article, we will answer some frequently asked questions (FAQs) related to the PLSQL JSON_OBJECT_T error code.

Q&A

Q: What is the PLSQL JSON_OBJECT_T error code?

A: The PLSQL JSON_OBJECT_T error code is ORA-40573, which occurs when you try to use the JSON_OBJECT_T type in a PL/SQL context where it is not supported.

Q: What are the causes of the PLSQL JSON_OBJECT_T error code?

A: The causes of the PLSQL JSON_OBJECT_T error code include:

Incorrect usage: The JSON_OBJECT_T type is not supported in all PL/SQL contexts.
Version compatibility: The JSON_OBJECT_T type is available in Oracle Database 12c and later versions.
Syntax errors: Make sure that your PL/SQL code is free from syntax errors.

Q: How do I resolve the PLSQL JSON_OBJECT_T error code?

A: To resolve the PLSQL JSON_OBJECT_T error code, follow these steps:

Check the PL/SQL context: Make sure that you are using the JSON_OBJECT_T type in a valid PL/SQL context.
Check the version compatibility: Make sure that your Oracle database version is compatible with the JSON_OBJECT_T type.
Check the syntax: Make sure that your PL/SQL code is free from syntax errors.
Use a different data type: Consider using a different data type if the JSON_OBJECT_T type is not supported in your context.
Upgrade your database: If you are using an earlier version of Oracle Database, consider upgrading to a version that supports the JSON_OBJECT_T type.

Q: What are some common use cases for the PLSQL JSON_OBJECT_T type?

A: Some common use cases for the PLSQL JSON_OBJECT_T type include:

Creating JSON objects: You can use the JSON_OBJECT_T type to create JSON objects in your PL/SQL code.
Extracting JSON values: You can use the JSON_VALUE function to extract JSON values from a JSON object.
Working with JSON data: You can use the JSON_OBJECT_T type to work with JSON data in your PL/SQL code.

Q: What are some best practices for using the PLSQL JSON_OBJECT_T type?

A: Some best practices for using the PLSQL JSON_OBJECT_T type include:

Use the correct data type: Make sure that you are using the correct data type for your JSON data.
Check the version compatibility: Make sure that your Oracle database version is compatible with the JSON_OBJECT_T type.
Use a different data type if necessary: Consider using a different data type if the JSON_OBJECT_T type is not supported in your context.

Conclusion

The PLSQL JSON_OBJECT_T error code is a common error that occurs when you try to use the JSON_OBJECT_T type in a PL/SQL context where it is not supported. By following the steps outlined in this article, you can resolve the error and successfully use the JSON_OBJECT_T type in your PL/SQL code. Remember to check the PL/SQL context, version compatibility, syntax, and use a different data type if necessary.

Additional Resources

For more information on the PLSQL JSON_OBJECT_T type, see the Oracle documentation:

For more information on PL/SQL, see the Oracle documentation: