This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Stat 5.3: Migrating Oracle Stored Procedures in Peoplesoft?

Urgent! I need to know how, or if even possible, to use STAT to migrate Oracle stored procedures. I am one of three Oracle DBAs supporting tightly locked down environment and the developers are demanding access to create and compile proprietary Oracle stored procedures in the development environment. At this point, we have only a handful of procedures (<~50) that have been developed over the years and require maintenance. We have tightened security in our database environments and have restricted compilations of source to a developer's private account. Now, the issue is - how to use STAT to add the procedure to a PeopleSoft archive set and to allow the developers to execute a build using App Designer (albeit, only in development) that creates the procedure in the development database IN THE PEOPLESOFT schema?

Parents
  • Dennis,  Sorry for the very delayed response.  Yes, STAT can migrate Oracle Stored procedures.  Out of the box support is included for the following PL/SQL and DDL types.

    • Package specification
    • Package Body
    • Procedure
    • Function
    • View
    • Trigger
    • Table
    • Index
    • Synonym
    • Sequence

    I hope this helps.

Reply
  • Dennis,  Sorry for the very delayed response.  Yes, STAT can migrate Oracle Stored procedures.  Out of the box support is included for the following PL/SQL and DDL types.

    • Package specification
    • Package Body
    • Procedure
    • Function
    • View
    • Trigger
    • Table
    • Index
    • Synonym
    • Sequence

    I hope this helps.

Children
No Data