0 Replies Latest reply on Sep 19, 2007 3:25 PM by Wilson Zhang

    How to call stored procedure in data services?

    Wilson Zhang
      Hi, all,

      I'm a newbie and am trying to evaluate Flex for our development environment. We use a lot of Oracle stored packages in the database to process the business logic. However, I can't seem to find a good example to call a stored procedure in flex data services.

      Here is a part of my data-management-config.xml:

      <destination id="oracle2">

      <adapter ref="java-dao" />
      <properties>
      <use-transactions>true</use-transactions>
      <source>flex.data.assemblers.SQLAssembler</source>
      <scope>application</scope>
      <metadata>
      <identity property="GKEY"/>
      </metadata>
      <network>
      <session-timeout>20</session-timeout>
      <paging enabled="false" pageSize="10" />
      <throttle-inbound policy="ERROR" max-frequency="500"/>
      <throttle-outbound policy="REPLACE" max-frequency="500"/>
      </network>
      <server>

      <database>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <url>jdbc:oracle:thin:xxxxxxxxxxx:1521/racdev</url>
      <login-timeout>15</login-timeout>
      </database>
      <actionscript-class>History</actionscript-class>

      <fill>
      <name>by_nbr</name>
      <sql>select to_char(POSTED,'dd-Mon-yyyy hh:mi:ssAM') POSTED, GKEY, EQUSE_GKEY,WTASK_ID,VSL_ID,VOY_NBR,STATUS from equipment_history where eq_nbr = #sNbr# order by posted desc</sql>
      </fill></server>
      </properties>
      </destination>

      How do I call a stored procedure named pk_equipment_history.get(eq_nbr varchar2, o_resultset out sys_refcursor) in place of the sql select in the above file? The o_resultset output parameter will return exactly the same result as the sql. How do I bind the output parameter?

      TIA