ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== prepareSp ======
~~NOTOC~~
<WRAP info>
Support for this function is limited. See the [[v5:database:feature_comparison]].
</WRAP>
<WRAP right box>
== See Also ==
[[v5:reference:connection:prepare]]\\
== Syntax ==
  mixed prepareSp (
      string $procedureName
  )
  
</WRAP>

===== 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 =====
<code php>
/*
 * 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');
</code>