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"))

iNTERFACEWARE™ Inc.

Using a Stored Procedure