Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

How to call stored procedure in data services?

Avatar

Level 1
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
0 Replies