This content has been marked as final. Show 5 replies
You cannot have this functionality defined at the table level; but you can call a stored procedure by passing all the field values of the table. Let the stored proc insert the data and do a select operation on the table to get the auto incrementing number generated based on other fields and return that number to the BPEL
Hope this helps
I am trying to do it with a stored procedure.
Problem is this is my first stored procedure ever written,
it was kind of hard to find good examples on the www.
It compiles, and i have linked a DbAdapter to this procedure.
create or replace procedure "CREATEFACTUUR" (p_nummer IN NUMBER, p_klant_id IN NUMBER, p_datum IN DATE, o_result OUT sys_refcursor) is begin INSERT INTO FACTUUR (NUMMER, KLANT_ID, DATUM) VALUES (p_nummer, p_klant_id, p_datum); OPEN o_result FOR SELECT * FROM factuur WHERE nummer = p_nummer AND klant_id = p_klant_id AND datum = p_datum; end;
But what now? How to get the values from the result of this procedure,
i mean that JDeveloper sees the result and i can return it in the repsonse of the webservice.
Edited by: 908157 on 21-mei-2012 14:51