execute-command Function

Summary

Executes a SQL expression.

Package

sql

Signature

execute-command sql-exp &key database

Arguments

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