2.8.8 drop JSON support? ORA-40569: Unimplemented JSON feature.

[viplifes]

Version 2.8.7 work fine!

Versions 2.8.8 - 2.8.11 have error: ORA-40569: Unimplemented JSON feature.

package main

import (
	"database/sql"
	"fmt"

	go_ora "github.com/sijms/go-ora/v2"
)

func main() {

	connOra, err := sql.Open("oracle", go_ora.BuildUrl("127.0.0.1", 1521, "ORCLPDB1", "SYS", "dbpaSS1#", nil))
	if err != nil {
		panic(err)
	}
	defer connOra.Close()
	run(connOra)
	// print
	// OCIBlobLocator OCIBlobLocator
}

func run(conn *sql.DB) {
	conn.Exec(`GRANT CREATE SESSION TO SYS`)
	conn.Exec(`DROP TABLE IF EXISTS types_test`)
	conn.Exec(`CREATE TABLE types_test (myblob BLOB NULL, myjson JSON NULL)`)
	conn.Exec(`INSERT INTO types_test (myblob, myjson)VALUES(UTL_RAW.CAST_TO_RAW('blobval - not json'), json('{"foo": "bar"}'))`)

	rows, err := conn.Query(`SELECT * FROM types_test`)
	if err != nil {
		panic(err)
	}
	cTypes, _ := rows.ColumnTypes()
	fmt.Println(cTypes[0].DatabaseTypeName(), cTypes[1].DatabaseTypeName())
}

[sijms]

HI @viplifes
I run the code with multiple version of go-ora (latest, v2.8.7, 2.7.21) and all failed at this stmt:

INSERT INTO types_test (myblob, myjson)VALUES(UTL_RAW.CAST_TO_RAW('blobval - not json'), json('{"foo": "bar"}'))

with this error

ORA-40445: unsupported JSON operation

to confirm I run same statement on SQL Developer and get same error
my database version is 19c

[sijms]

when I change the insert statement and remove json keywords everything is ok

INSERT INTO types_test (myblob, myjson)VALUES(UTL_RAW.CAST_TO_RAW('blobval - not json'), '{"foo": "bar"}'); 

[viplifes]

I use docker image hub.docker.com/gvenzl/oracle-free:23-slim

https://hub.docker.com/r/gvenzl/oracle-free

[sijms]

fixed in next release

[sijms]

fixed v2.8.13