Looking for Iguana v.5 or v.6? Learn More or see the Help Center.
Using a Stored Procedure |
Stored procedures can be called using Python within Chameleon, just like any other query. Although the Python wrapper does not provide parameter binding, you can still compose a query directly with all parameters.
The following code example demonstrates how to call a stored procedure from an inbound script:
# Use the environment variable to retrieve the default
# database. This is either the database specified in
# the DB tab of the Options window, or it is the
# database associated with your channel if you are
# using Iguana.
# Note: if database support is turned off, you'll still
# get a database object back.
db = environment.get_default_database()
# If the stored procedure returns a result set, then you
# must call execute_select, otherwise call execute().
# This is an example of running a stored procedure that
# retrieves patient information based on an ID.
resultSet = db.execute_select("EXECUTE sp_GetPatient '" + patient_id + "'")
# This example just demonstrates how to log the given and
# family name of the patient.
if (resultSet != 1):
for RowIndex in range(0, resultSet.count_of_row() ):
log(resultSet.value(RowIndex, "GivenName"))
log(resultSet.value(RowIndex, "FamilyName")) |