Comments (3)
Now i use SET TRANSACTION NAME 'some-name'
if it's good?
from erloci.
I would build all SQLs into a BEGIN .. END
block at string level:
So instead of
session.prep_sql("BEGIN").exec_stmt()
session.prep_sql(sql1).exec_stmt()
session.prep_sql(sql2).exec_stmt()
session.prep_sql("COMMIT").exec_stmt()
I would
session.prep_sql("BEGIN "++sql1++" "++sql2++" COMMIT END").exec_stmt()
I don't know elixir syntax, so assumed ++
is supported as in erlang
Example: https://github.com/K2InformaticsGmbH/erloci/blob/master/test/erloci_test.erl#L699-L754
However
SET TRANSACTION NAME 'some-name'
gives you better control, as you can COMMIT
or ROLLBACK
as separate statements.
In the end your choice of approach will depend on your use case requirement.
from erloci.
ok, good i can use SET TRANSACTION NAME 'some-name'
i like it.
Thanks!
from erloci.
Related Issues (20)
- Add support to cancel long running statements.
- add optional client identifier support
- fetch_rows called without executing stmt results in cryptic error
- Hour,Minutes,Seconds increased by 1 HOT 1
- Unoptimized oci_util:to_num
- Error starting a session HOT 1
- Continuous Query Notification (CQN) support
- 008741 Debugging API for erloci port implementation
- Memory Leak HOT 1
- reading RAW fields is truncating at byte 0
- query execute failure on SBS test installation HOT 2
- add support for fetch_rows(N, WaitTime)
- Error reading CLOB in logger_log HOT 1
- Timestamp fractional seconds internal oracle representation. HOT 5
- DB NULL should be distinguishable in row values
- Add support to edit CLOBS HOT 2
- Length param isn't respected in Stmt:lob(LobId, Offset, Length) HOT 1
- One failed query can prevent future queries working
- Using SQLT_VNU as an in out parameter fails
- Argument error using OTP 22 HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from erloci.