News

31 August 2024 - AQT v11.0.7

We are currently working on AQT v11.0.7.

We have been doing some work on the Run Procedure window and improving support for procedures for various databases.

• when procedures return a result-set, AQT will now display this on the Run Procedure window, rather than on a separate display window. AQT can handle procedures returning multiple result-sets.
• the Run Procedure window will now be able to run functions as well as procedures. This feature has been configured for DB2, Oracle, SQL Server, MySQL, MariaDB, PostgreSQL, Snowflake.
• AQT will be able to run Oracle Package sections. This includes both procedure and function sections.
• AQT will be able to handle MySQL / MariaDB procedures which return OUT parameters. For these databases, OUT parameters are returned in session pseudo-variables; AQT will display these.
• AQT will be able to run Snowflake procedures. Running these has proved problematic due to various bugs in the Snowflake ODBC Driver or server. We have managed put in workarounds for these bugs and are able to run procedures successfully.
• AQT will be able to run PostgreSQL procedures and functions which return a refcursor. AQT will automatically read the refcursor and display the results.