Hi Phearith,
thanks for confirming
the problem i was trying to solve was how to setup a job to create fixed user database links using the primary login to set the database the link was to created in, and the secondary login to obtain the username/password required as part of the dblink definition
the context to the problem relates to rebuilding all the database links in a database after it's been refreshed from a production copy - we can obtain the names of the databases that the dblinks should connect to, and the usernames the links need to be setup with, so all we need is the passwords in order to rebuild the links. Conveniently, we have AM dblogins defined for all these user
After a bit of thought i settled on using the awapi.aw_module and aw_module_prompts procedures to dynamically create a job with the appropriate primary and secondary logins set and then submit it using awop_api.awrun
regards
Pat