Table of Contents

, , , ,

EXEC_SPF

Description

Executes the specified stored procedure and returns a value in the OUT parameter of the stored procedure. The stored procedure must have one and only one OUT parameter defined. All other parameters (if any) should be IN parameters. The returned valus is of Plain Text type. If you need to convert it to number use the AS_NUMBER function on the result

Parameters

The first parameter is the name of the stored procedure to execute. The second parameter is the string identifying database environment ('MAIN' for the native one).All other parameters (if any) are IN parameters of the stored procedure

Example

IF EXEC_SPF ('ContactNotesCount', 'MAIN', Customer.ID) = 4 THEN ...