I want to init session parameters like ' ALTER SESSION SET key=value' and keep this wh

Is there a way to init session parameters always whenever connection created about go-ora HOT 5 CLOSED

freeNestor commented on August 27, 2024

Is there a way to init session parameters always whenever connection created

from go-ora.

Comments (5)

sijms commented on August 27, 2024 1

sorry for late replay
ok good idea I will add it in next release

from go-ora.

DrHayt commented on August 27, 2024

What parameter are you trying to set? Is it already an option in the connect string?

Take a look at:

go-ora/v2/connection_string.go

Line 405 in 47c7295

 func newConnectionStringFromUrl(databaseUrl string) (*ConnectionString, error) { 

from go-ora.

freeNestor commented on August 27, 2024

What parameter are you trying to set? Is it already an option in the connect string?

I want to set events and cursor_sharing etc.
Example:
ALTER SESSION SET EVENTS '10503 trace name context forever, level 4000'
ALTER SESSION SET cursor_sharing=force

like godror can achieve this:

from go-ora.

freeNestor commented on August 27, 2024

Thanks very much, I'll wait for it.

from go-ora.

sijms commented on August 27, 2024

fixed in v2.7.20

from go-ora.

Related Issues (20)

How to insert a null BFILE filed value? HOT 2
Can db *sql.DB support BFILE type query? HOT 2
Can't support BLOB type for the bulk insert HOT 16
Not all rows are inserted when reusing the same prepared statement HOT 2
Issue with REF CURSOR HOT 3
New issue with REF CURSOR HOT 2
Oralce 23c wallet support. HOT 8
Can't support BFILE type for the bulk insert HOT 2
BLOB limited to 32kB HOT 3
Issue in parseSqlText function HOT 1
Client timezone is not honored? HOT 9
PGA memory leak with LOBs (Regression) HOT 12
Readme Output Parameters Example Does Not Work HOT 3
ORA-01013 Error occurs seemingly randomly running a queries in a loop HOT 3
Query panic HOT 12
Driver Character Set support Issue HOT 4
Regression since v2.7.23 when using DBMS_AQ.DEQUEUE_ARRAY HOT 2
Add support for Oracle proxy users HOT 6
v2.7.25 now requires Go v1.21? HOT 3
TTC error: received code N during response reading (v2.7.26) HOT 11

Is there a way to init session parameters always whenever connection created about go-ora HOT 5 CLOSED

Comments (5)

Related Issues (20)

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent