looking for some solutions? You are welcome.

SOLVED: What is the Execution Flow in E-BIZ Concurrent Program XML files?

Shanmukha Reddy:

As part of my project I wrote an XML report which extract rows from a Oracle SQL statement and then give the rows in XML format as output.(When executed through E-BIZ Concurrent Program).

Here I attached the Structure of my XML and I need to understand the flow of it to debug the errors receiving.

i cannot share the exact XML has it would be organisations compliance issue. So sharing a similar snippet. I want to know how the execution works.How the execution pointer moves. For eg:

<?xml version="1.0" encoding="UTF-8"?>
    <dataTemplate version="1.0" description="XXX_XXX_XXX" 
        name="XXX_XXX_XXX">
        <parameters>
            <parameter name="P_START_DATE" dataType = "DATE"> </parameter>
            <parameter name="P_END_DATE" dataType = "DATE"> </parameter>
            <parameter name="P_DEPARTMENT" dataType = "NUMBER"> </parameter>
        </parameters>
     <lexicals> </lexicals>
     <dataQuery>
        <sqlStatement name="Q_1">
            <![CDATA[
                SELECT *  FROM EMPLOYEE WHERE DATE_OF_JOINING BETWEEN 
                :P_START_DATE AND :P_END_DATE AND DEPARTMENT = :P_DEPARTMENT
            ]]>

        </sqlStatement>
     </dataQuery>
     <dataStructure>
            <group name="G_1" dataType="varchar2" source="Q_1">
                                <element name="SUPERVISOR_NAME" dataType="VARCHAR2" value="SUPERVISOR_NAME"/>
                                <element name="EMPLOYEE_NAME" dataType="VARCHAR2" value="EMPLOYEE_NAME"/>
                                <element name="EMPLOYEE_NUMBER" dataType="NUMBER" value="EMPLOYEE_NUMBER"/>
                                <element name="DEPARTMENT" dataType="VARCHAR2" value="DEPARTMENT"/>
                                <element name="EMPLOYEE_EMAIL" dataType="VARCHAR2" value="EMPLOYEE_EMAIL"/>
                                <element name="SALARY" dataType="NUMBER" value="SALARY"/>
                </group>
     </dataStructure>
    </dataTemplate>

Will the Sql statements execute first and then the data structure display one row picking from the fetched rows OR Will they run in parallel?



Posted in S.E.F
via StackOverflow & StackExchange Atomic Web Robots
Share:

No comments:

Recent