Conflicting examples in JSON type direct binding

[ryotayamanaka]

What is the link to the documentation section that needs improving?

"Using the Oracle Database 21c JSON Type in python-oracledb" section and its example (json_direct.py).

• python-oracledb/doc/src/user_guide/json_data_type.rst

  Lines 69 to 71 in c5c6b4f

  	data = [
  	(5, dict(name="Sally", dept="Sales", location="France")),
  	]

• python-oracledb/samples/json_blob.py

  Line 65 in c5c6b4f

  data = dict(name="Rod", dept="Sales", location="Germany")

Describe the confusion

The following examples are using the dictionary differently.

    data = [
      (5, dict(name="Sally", dept="Sales", location="France")),
    ]
...
    cursor.execute(insert_sql, [1, data])

    data = dict(name="Rod", dept="Sales", location="Germany")
...
    cursor.execute(insert_sql, [1, data])

Suggest changes that would help

I hope to know which is the right way. Thank you.

[cjbj]

Thanks for reporting the concern.

Use the examples in https://github.com/oracle/python-oracledb/tree/main/samples because they run. Which file and code path to use depends on your table definition and your DB version (and the client version, if you are using Thick mode).

We'll fix the documentation code snippet.

[cjbj]

This was fixed in d607ef9