How to write Stored Procedure call
Can someone tell me how to write a stored procedure call for inserting following data into a database:
Manuel Bassani replied
I assume your scenario is JDBC receiver adapter...
im using a stored procedure to insert values into an Oracle DB. I created the stored procedure in the DB system:
create or replace procedure InsertSP( RECTYPEIND in CHAR, JENUMBER in CHAR, COMPANY in CHAR, CONSTANT1 in CHAR, SYSTEMDATE in CHAR, DR_CR_ID in CHAR, AMOUNT in CHAR, MONTH_NUMBER in CHAR, COST_CENTER in CHAR, ORDERNO in CHAR, WBS in CHAR, ACCOUNTID in CHAR, BATCH_ID in CHARR, ASSIGNMENT in CHAR, GL_JOURNAL_CATEGORY in CHAR, PROFIT_CENTER in CHAR, REFDOCNUMBER in CHAR ) is begin Begin insert into <TABLE NAME> values (RECTYPEIND, JENUMBER, COMPANY, CONSTANT1, SYSTEMDATE, DR_CR_ID, AMOUNT, MONTH_NUMBER, COST_CENTER, ORDERNO, WBS, ACCOUNTID, BATCH_ID, ASSIGNMENT, GL_JOURNAL_CATEGORY, PROFIT_CENTER, REFDOCNUMBER); end; end InsertSP;
at this point you can call the SP from JDBC adapter. set action="EXECUTE" (see <a href="http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm">Document Formats for the Receiver JDBC Adapter</a>)