EPUB | CHM | PDF

TPSQLStoredProc.Properties.Overload

Top Previous Next

Specifies which PostgresSQL overloaded stored procedure to execute.

Syntax:

property Overload: Word;

Description:

Use Overload to specify which overloaded stored procedure to execute on an PostgresSQL server. An PostgresSQL overloaded stored procedure is one that shares a name with one or more other stored procedures. PostgresSQL distinguishes among stored procedures by assigning each procedure a unique numeric identifier, called OID. An application can specify this identifier using the Overload property.

By default, Overload is zero, which assumes there is no procedure overloading. If an application attempts to access an PostgresSQL overloaded procedure without setting Overload, the PSQLDAC Engine accesses the lowest numbered, or first, overloaded procedure on the server.

While PostgresSQL overloaded procedures share names, their parameter lists are unique. An application must ensure that it passes the correct parameter list to an overloaded procedure.

See also: Params