Function

Summary

Executes a SQL expression.

Package

sql

Signature

execute-command sql-exp &key database =>

Arguments

sql-exp

Any SQL statement other than a query.

database

A database.

Values

None.

Description

The function execute-command executes the SQL command specified by sql-exp for the database specified by database, which has a default value of *default-database*. The argument sql-exp may be any SQL statement other than a query.

To run a stored procedure, pass an appropriate string. The call to the procedure needs to be wrapped in a PL/SQL BEGIN END pair, for example:

 (sql:execute-command

 "BEGIN my_procedure(1, 'foo'); END;") 

See also

*default-database*
query