call db procedure a with ResultSet [[param &1 = c], d,e, f,g,h,i], [column of ResultSet j = 1], default k,l dbAlias = b
|
Group |
Executes a stored procedure (SQL statement) a on the database being represented by alias b. Placeholders in the form of ¶meterNumber being defined in the statement are replaced by the values of parameters c to i. Characters that are needed for a valid syntax need to be placed in the statement. The number of selected rows is limited to 1 automatically.
If the database returns a result set, the value of the column with number j is returned. Otherwise, k is returned.
Is a column being selected of type BLOB, the parameter m allows to specify if the data being selected should be encoded with Base64 before being added to the result list. If m is true, the function performs the encoding, false will leave the data unchanged. If there are no columns of type BLOB, the parameter has no effect.
Description of Parameters
|
Parameter |
Description |
|
a |
SQL statement. |
|
b |
DB alias. |
|
c |
(optional) Input parameter &1. |
|
d |
(optional) Input parameter &2. |
|
e |
(optional) Input parameter &3. |
|
f |
(optional) Input parameter &4. |
|
g |
(optional) Input parameter &5. |
|
h |
(optional) Input parameter &6. |
|
i |
(optional) Input parameter &7. |
|
j |
(optional) Column from result set. Offset is 1. |
|
k |
Default value. |
|
l |
Encode Base64 blob content {true, false}. |
Examples
Defined is a stored procedure GetAllProfiles(search), which returns the profile ID and profile name as result set.
|
Parameter a |
CALL GetAllProfiles("&1") |
CALL GetAllProfiles("&1") |
CALL GetAllProfiles("&1") |
|
Parameter b |
testdb |
testdb |
testdb |
|
Parameter c |
demoprofile |
demoprofile |
demoprofile |
|
Parameter d…i |
|
|
|
|
Parameter j |
2 |
1 |
1 |
|
Parameter k |
error |
error |
error |
|
Result |
DemoProfile |
6872263c:12fd93fea8f:-37a4.1feefd6229b797f1:6872263c:12fd93fea8f:-7ff8 |
error |
Note: The examples above apply to a call in a MySQL database. If the executing database is an MSSQL, embed the actual statements in brackets, e.g. {CALL GetAllProfiles("&1")} (so put the SQL statement in curly brackets). For other databases, please refer to the documentation of the respective manufacturer for the correct syntax.
For other databases, please refer to the documentation of the respective manufacturer for the correct syntax.
See Also
select-statement a [[param &1 = c], d,e, f,g,h,i,j], default k,l dbAlias = b
exists db-row(select-statement a [[param &1 = c], d,e,f,g,h,i,j])
select into map(a,b,[param &1 = c], d,e, f,g,h,i,j], delimiter k, map l, m)
set-vars(select a, dbalias b, [c,d,e,f,g,h,i,j for params &1...&8][,k,l,m,n])
update-statement a [[param &1 = c], d,e, f,g,h,i,j], dbAlias = b