/usr/man2/cat.l/execute.l.Z(/usr/man2/cat.l/execute.l.Z)

NAME

       EXECUTE - execute a prepared statement

SYNOPSIS

       EXECUTE plan_name [ (parameter [, ...] ) ]

DESCRIPTION

       EXECUTE  is used to execute a previously prepared statement. Since pre-
       pared statements only exist for the duration of a session, the prepared
       statement  must  have been created by a PREPARE statement executed ear-
       lier in the current session.

       If the PREPARE statement that  created  the  statement  specified  some
       parameters,  a  compatible set of parameters must be passed to the EXE-
       CUTE statement, or else an error is raised.  Note  that  (unlike  func-
       tions) prepared statements are not overloaded based on the type or num-
       ber of their parameters; the name  of  a  prepared  statement  must  be
       unique within a database session.

       For  more information on the creation and usage of prepared statements,
       see PREPARE [prepare(l)].

PARAMETERS

       plan_name
              The name of the prepared statement to execute.

       parameter
              The actual value of a parameter to the prepared statement.  This
              must be an expression yielding a value of a type compatible with
              the data type specified for this parameter position in the  PRE-
              PARE command that created the prepared statement.

OUTPUTS

       The  command tag returned by EXECUTE is that of the prepared statement,
       and not EXECUTE.

EXAMPLES

       Examples are given in the Examples [prepare(l)] section of the  PREPARE
       [prepare(l)] documentation.

COMPATIBILITY

       The  SQL standard includes an EXECUTE statement, but it is only for use
       in embedded SQL. This version of the  EXECUTE  statement  also  uses  a
       somewhat different syntax.

SEE ALSO

       DEALLOCATE [deallocate(l)], PREPARE [prepare(l)]

SQL - Language Statements         2005-11-05                         EXECUTE()