Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list

Insert a DB record and receive the Record ID

Avatar

Not applicable
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

Level 6
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