search

sijms / go-ora

Pure go oracle client
MIT License
771 stars 169 forks source link

Fail to set Session Parameter Container fails with ORA-65015: missing or invalid container name #514

Closed nchillal closed 5 months ago

nchillal commented 5 months ago

I am trying to set container using "AddSessionParam" and it fails with message below

ORA-65015: missing or invalid container name

"AddSessionParam" code is using single quotes around the value but for containers this doesn't work. 

SQL> alter session set CONTAINER='PDBTEST';
alter session set CONTAINER='PDB10'
                            *
ERROR at line 1:
ORA-65015: missing or invalid container name

This works 

SQL> alter session set CONTAINER=PDBTEST;

Session altered.

Can you please provide a fix for this?

sijms commented 5 months ago

which version are you using? fixed in last version