Does the dbExpress driver support Oracle temporary tables? Just an idea for a workaround for the PL/SQL stored subprogram parameter limitation - insert (any number of) records into a temporary table (transaction scoped data) and then call a stored PL/SQL subprogram (within the same transaction) to use the data instead of getting it through parameter passing.
Thanks.
barbados
Search found 2 matches
- Thu 14 Aug 2014 00:33
- Forum: dbExpress driver for Oracle
- Topic: Passing array to a stored procedure
- Replies: 12
- Views: 6235
- Mon 24 Feb 2014 19:26
- Forum: dbExpress driver for Oracle
- Topic: What is a cursor in the dbMonitor Object tree?
- Replies: 4
- Views: 3281
Re: What is a cursor in the dbMonitor Object tree?
Another related issue - the TSQLMonitor.Active property setting (true/false) does not seem to control anything.
The documentation says:
The documentation says:
In our environment the output to DBMonitor GUI happens regardless of the setting of this property. In order to truly dosable this we have to blank the TSQLMonitor.SQLConnection property. A bug?Starts or stops the monitor from recording SQL commands passed to the database server.
Set Active to true to start monitoring the communication between SQLConnection and its database server. Set Active to false to stop the monitoring.