In ColdFusion, I have the following cfstoredproc being called with 3 inputs and 6 outputs.
<cfstoredproc procedure="si_updateProject" datasource="#mydsn#" returncode="yes">
<cfprocparam type="IN" cfsqltype="CF_SQL_VARCHAR" value="#platform#">
<cfprocparam type="IN" cfsqltype="CF_SQL_VARCHAR" value="#projectData#">
<cfprocparam type="IN" cfsqltype="CF_SQL_VARCHAR" value="#sysData#">
<cfprocresult name="projectInfo" resultSet=1>
<cfprocresult name="newPSA" resultSet=2>
<cfprocresult name="newStatus" resultSet=3>
<cfprocresult name="goliveSystems" resultSet=4>
<cfprocresult name="goliveHistory" resultSet=5>
<cfprocresult name="newSystems" resultSet=6>
</cfstoredproc>
Within in the stored procedure, si_updateProject
, how do I identify the 6 resultSet queries as listed for the resultSets? The stored proc has several statements (select, updates, deletes, etc).
(Synopsis from comments above ..)
I am not aware of any method other than eyeballing the sql for
SELECT
statements that generate a result and comparing thecolumnList
values.When I need to test modifications to a stored procedure involving virtual tables, I usually just comment out the
CREATE PROCEDURE ... BEGIN
andEND
statements and run the sql manually in the query analyzer. Very low tech, but useful for quick testing.