The function prepareSP() accesses an existing stored procedure. If the stored procedure is valid the function return a resource otherwise it returns false.

prepareSp should only be used with database drivers that support direct access to the procedures. It should not be passed an SQL statement that might access the procedure so, assuming a stored procedure PROC_LIST exists, the statement:

$db->prepareSp('PROC_LIST') 

is correct, however

 $db->prepareSp('CALL PROC_LIST')

is not.

/*
 * Connection to SQL Server database
*/
 
/*
 * Accessing an existing stored procedure called kmnProc
 */
$stmt = $db->PrepareSP('kmnProc');
$val1 = 'ADMIN';
$par1 = 'users';
$db->InParameter($stmt,$val1,$par1);
$db->OutParameter($stmt,$ret,'RETVAL');