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.

Insert a DB record and receive the Record ID

Avatar

Former Community Member
Hi !



I'm trying to populate a DB (two tables) based

on the classic master/detail approach.



These steps represent what I would like to achieve :

1) add the master record and get the corresponding primary key

2) add multiple records in another table using the Master Prim.key



That seems to be so simple,

but I have no idea how to get the Master PrimaryKey.



Thanks.

GB.
1 Reply

Avatar

Former Community Member
You can't get a result back from the standard database call. If there is another unique field, you could query again based on that. I needed something with one child record. I did the whole thing in a PL/SQL block passing all the parameters to one call.



To get a value back from a call, look at this thread: http://www.adobeforums.com/webx/.59b7d6b1/3