psr_datasource_query.lwm 1.97 KB
Newer Older
Spencer Chang's avatar
Spencer Chang committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
<?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>