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;")