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.

Calling a Stored Procedure from Oracle

Avatar

Level 10

Hi,

    I am new to the workbench.. Can some one help me on how we can make a call to the Oracle Stored procedure which will store the data back to the tables..

    I read that we can use the JDBC Service in the workbench but any one help me how we can do that..The idea is store the xml data from the PDF to the LiveCycle database and then from the LiveCycle database first and then on a nightly feed the data needs to be stored in Oracle database.

Thank you for your help.

Srini

3 Replies

Avatar

Level 10

The client would like to store the submitted data from the PDF in the form of XML to Oracle database. The company has existing stored procedures to insert the data into the database tables. So they are asking us to use the existing stored procedures. If the stored procedures are not supported then we can propopse the user to go with the insert statements. Can you please confirm if this is possible? If so how can I do it?

Thanks

Srini

Avatar

Former Community Member

Sorry. My original post was in error.

Stored procedures are supported in LiveCycle ES.

Steve