12.12 Common SQL changes

12.12.1 New helper functions and macro for prepared statements

The new functions sql:prepared-statement-set-and-execute, sql:prepared-statement-set-and-execute*, sql:prepared-statement-set-and-query and sql:prepared-statement-set-and-query* can be used to set the variables of a sql:prepared-statement and then execute or query using it.

The new macro sql:with-prepared-statement execute codes with a variable bound to a new prepared-statement and destroys it afterwards.

12.12.2 Calling connect with :if-exists and without :name

An error is signaled now if the name argument to the function sql:connect is not supplied and the if-exists argument is supplied with any value except :new. This is because there is no way to find an existing connection unless name is supplied.

12.12.3 New condition class signaled by connect

The new condition class sql:sql-failed-to-connect-error can be signaled by sql:connect for a failure to connect to a SQL database server. It typically indicates an incorrect connection specification such as a bad user name.

12.12.4 Some missing LOB functions are now exported

The functions sql:ora-lob-get-chunk-size and sql:ora-lob-file-set-name are now exported. They have been documented since LispWorks 5.0, but the symbols were not exported.

They were missing due to a bug.