<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: qwm $Date: 2012-11-28 上午11:21:37 $Revision: 1.0 $Purpose: --> <bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm"> <bm:operations> <bm:operation name="query"> <bm:query-sql><![CDATA[ /* select t.sql_statement sql_text from psr_report_headers t where t.report_header_id = 10081 */ select psr_report_pkg.create_report( p_report_header_id =>${@report_header_id}, p_parameter_1 =>${@parameter_1}, p_parameter_1_value =>${@parameter_1_value}, p_parameter_2 =>${@parameter_2}, p_parameter_2_value =>${@parameter_2_value}, p_parameter_3 =>${@parameter_3}, p_parameter_3_value =>${@parameter_3_value}, p_parameter_4 =>${@parameter_4}, p_parameter_4_value =>${@parameter_4_value}, p_parameter_5 =>${@parameter_5}, p_parameter_5_value =>${@parameter_5_value}, p_parameter_6 =>${@parameter_6}, p_parameter_6_value =>${@parameter_6_value}, p_parameter_7 =>${@parameter_7}, p_parameter_7_value =>${@parameter_7_value}, p_parameter_8 =>${@parameter_8}, p_parameter_8_value =>${@parameter_8_value}, p_parameter_9 =>${@parameter_9}, p_parameter_9_value =>${@parameter_9_value}, p_user_id =>${/session/@user_id}) sql_text from dual ]]></bm:query-sql> </bm:operation> </bm:operations> <bm:fields> <bm:field name="sql_text" databaseType="VARCHAR2" datatype="java.lang.String"/> </bm:fields> </bm:model>