Provide examples and test cases for lobvar insert/updates

[qqiao]

We currently have example for lobvar reads:

goracle/godrv/driver_test.go

Line 86 in 798cff6

clob := dst.(*oracle.ExternalLobVar)

However, we don't have any examples or test cases for inserting/updating blob/clob columns, could these be added?

I hope I'm not missing anything obvious.

[tgulacsi]

Hi, just for heads up: I've noticed your request, but just don't have any free time these days.
I'll try to create an example, as soon as possible.

[tgulacsi]

I've added clob insertion test - see godrv/table_test.go insertClob function.
Sorry, but the shorter version (insert into ... () values() returning F_clob INTO :1) doesn't work for now - didn't have time to investigate whether it is Go's sql driver's limitation, or my fault.

[qqiao]

Thanks for the prompt reply.

The reason I raised this issue is because I was able to insert into CLOB columns using a normal string, for exmaple

CREATE TABLE temp (
c CLOB
)

Then in Go code:
s := "Some String"
db.Exec("INSERT INTO temp (c) VALUES (?)", a)

The above snippet is actually functional, and when I looked at ExternalLobVar, it has all the Write* functions, which is what got me nervous, the direct insertion almost felt like a fluke and I was expecting to have to use ExternalLobVar

I have not looked too deeply into the code, otherwise I'd PR test cases to the project.