Re: [PATCHES] prepareable statements

Joe Conway <mail@joeconway.com>

From: Joe Conway <mail@joeconway.com>
To: Mike Mascari <mascarm@mascari.com>
Cc: Rod Taylor <rbt@zort.ca>, Neil Conway <nconway@klamath.dyndns.org>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2002-07-23T23:23:30Z
Lists: pgsql-hackers
Mike Mascari wrote:
> FWIW, Oracle uses EXECUTE to execute stored procedures. It is not apart
> of the SQL language, but a SQL*Plus command:
> 
> EXECUTE my_procedure();
> 

Also with Transact SQL (i.e. MSSQL and Sybase)

Syntax
Execute a stored procedure:
[[EXEC[UTE]]
	{
		[@return_status =]
			{procedure_name [;number] | @procedure_name_var
	}
	[[@parameter =] {value | @variable [OUTPUT] | [DEFAULT]]
		[,...n]
[WITH RECOMPILE]


However, as Peter E. has pointed out, SQL99 uses the keyword CALL:

15.1 <call statement>
Function
Invoke an SQL-invoked routine.
Format
<call statement> ::= CALL <routine invocation>

FWIW,

Joe