regarding alter session commands and set define off

[crbsram]

Hi Team

Want to know how to add these
alter session set current_schema = user
set define off

during the connection initialization similar to onInit in godror.
So that entire connection usage these will be inherited.

Pls let us know this is possible.

[crbsram]

Update:
_, err := conn.Query("set define off")
if err !=nil {
fmt.Println("error in setdefine off")
}

_, err := conn.Query(" select name from user where name = 'test & test'")
if err != nil {
fmt.Println("error in executing the query")
}

while writing this code received error from Oracle like given below:

ORA-00922: missing or invalid option

Let me know if I am missing anything.

Thanks
C.R.Bala

[sijms]

hi @crbsram
SET DEFINE ON/OFF is an option of SQL Plus not oracle
so your code

_, err := conn.Query(" select name from user where name = 'test & test'")
if err != nil {
    fmt.Println("error in executing the query")
}

will work without SET DEFINE OFF