Use APIs

You can call public APIs from custom programs. For more information about APIs, see the Oracle Health Sciences Life Sciences Warehouse Application Programming Interface Guide—click the "Help" link from DMW, then click the Books link in the left pane.

Before calling an API or public view, you must call DME_PUB_INITIALIZATION.SetupAPIStudyEnvironment. This procedure checks that the study ID and lifecycle value you pass in are valid and then uses those values and the study's partition ID for the lifecycle stage to set SYS_CONTEXT appropriately. Call it again to change the study or lifecycle context.