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" />
      <identity property="GKEY"/>
      <paging enabled="false" pageSize="10" />
      <throttle-inbound policy="ERROR" max-frequency="500"/>
      <throttle-outbound policy="REPLACE" max-frequency="500"/>


      <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>

      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?