====== prepareSp ======
~~NOTOC~~
Support for this function is limited. See the [[v5:database:feature_comparison]].
== See Also ==
[[v5:reference:connection:prepare]]\\
== Syntax ==
mixed prepareSp (
string $procedureName
)
===== Description =====
The function ''prepareSP()'' accesses an existing stored procedure. If the stored procedure is valid the function return a resource otherwise it returns false.
===== PrepareSp Correct Usage =====
''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.
-------------------------------------
===== Usage =====
/*
* 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');