Clob / Blob sharing a problem and the solution

[amichelins]

With Go 1.20.5 and go-ora/v2 v2.8.5, begin to esperiment problems in insert clob or blob
The insert is ok, no errors, clob or blob field are null, the data passed to stmt.Exec are not saved

Code not working
`
-- sPedido -> string

stmt, err = txw.Prepare("INSERT INTO PEDIDOS_REQUEST(PEDSITE, REQUEST ) VALUES(:1,:2 )")

if err == nil {
     defer stmt.Close()
     _, err = stmt.Exec(StdPedido.PedSite, go_ora.Clob{String: sPedido})
}

-- Solution

stmt, err = txw.Prepare("INSERT INTO PEDIDOS_REQUEST(PEDSITE, REQUEST ) VALUES(:1,:2 )")

if err == nil {

    defer stmt.Close()

    _, err = stmt.Exec(StdPedido.PedSite, go_ora.Clob{String: sPedido, Valid: true})
}

`
Program begins to work as spected when i add "Valid" true, to go_ora.Clob