How to use prepared statement functionality ?

erlangbureau / jamdb_oracle

Oracle Database driver for Erlang

MIT License

106 stars 48 forks source link

How to use prepared statement functionality ? #87

Closed Rory-Z closed 3 years ago

Rory-Z commented 4 years ago

Hi, I want to use oracle insert preparedstatement, but I don't know how to use it, can you help me?

vstavskyi commented 4 years ago

Driver stores automatically IDs of all new executed statements with parameters and passes stored ID during next execution. jamdb_oracle_conn.erl#L319

So, just execute the same statement with new parameters and Server runs it as preparedstatement.

BTW Please test user and/or password containing CJK characters and give feedback. commit

Rory-Z commented 4 years ago

Hi, @vstavskyi Thank you for your reply. Sorry, I just contacted Oracle Database not long ago. I don’t know how to use CJK characters in the oracle database. I will search for it. If there is any problem, I will open a new issue to give you feedback.

vstavskyi commented 4 years ago

You can include multibyte characters in passwords.

alter user scott identified by 虎