Database-independent syntax for calls

The database-independent syntax for calling stored procedures is:

CALL [?=] procedure_name [(argument_list)]

The arguments are described below.

Option

Description

?=

Indicates that the return value from a stored function should be returned.

procedure_name

The name of the stored procedure or function. To invoke a stored procedure in an Oracle package, fully qualify the stored procedure name. For example:

                        schema_name.package_name.stored_ procedure_name
                     

argument_list

A comma-separated list of arguments in which each argument is one of the following:

Argument

Description

value

This is the value to be passed to an input parameter. If the value contains spaces, it must be surrounded by single quotation marks (for example, 'city of'). The quotation mark characters are not passed as part of the parameter.

?

Return the value from an output parameter.

X

Do not return the value from an output parameter.

?/value

This is the value to be passed to an In / Out parameter and the value to be returned from the parameter.