Differences

This shows you the differences between two versions of the page.

--- reference:preparesp [2015/08/15 02:02] – mnewnham
+++ v5:reference:connection:preparesp [2016/11/02 12:45] (current) – add link to comparison matrix dregad
@@ Line 2: / Line 2: @@
 ~~NOTOC~~
 <WRAP info>
-Support for this function is limited. See the feature compatibility matrix
+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 (
@@ Line 15: / Line 17: @@
 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 =====