Oracle (prepared statement)

Databases
1

I’m a new Xojo user. I’m testing, in Windows 10, Oracle 11g connection (both standard and XE version).
using OracleSQLPreparedStatement (1), the application crashes (both Desktop and Web), with a Windows message “Debug…has stopped working. Windows will close the program…”.
using sql instruction, the application works fine.

thanks in advance for your help.

  1. OracleSQLPreparedStatement example:

Dim ps As OracleSQLPreparedStatement
ps = OracleSQLPreparedStatement(Session.dbMain.Prepare(“SELECT * FROM X_UTENTI WHERE ID_UTENTE = :uID”))
ps.BindType(0,OracleSQLPreparedStatement.SQL_TYPE_INTEGER)
ps.Bind(0,72)
Dim rs As RecordSet
rs = ps.SQLSelect

  1. sql example:

Dim sql As String
sql = “SELECT * FROM X_UTENTI WHERE ID_UTENTE = 72”

Dim rs As RecordSet
rs = Session.dbMain.SQLSelect(sql)