All Manuals > LispWorks User Guide and Reference Manual > 47 The SQL Package

NextPrevUpTopContentsIndex

execute-command

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


LispWorks User Guide and Reference Manual - 20 Sep 2017

NextPrevUpTopContentsIndex