Automic Community

Expand all | Collapse all

Dollar Universe running SQL

  • 1.  Dollar Universe running SQL

    Posted 02-12-2019 06:46 PM

    I have been asked to see if our $Universe product can execute a SQL stored procedure? This is something that I have not tried and if you have an example I would appreciate reviewing it.

     

    Thanks,

     

    Chris

    650-474-1378

    clogan@smcgov.org



  • 2.  Re: Dollar Universe running SQL

    Posted 03-07-2019 12:28 PM

    The Manager for Oracle Database has a Stored Procedure section in the ODB_JOB uproc type.
    I am not sure if this is exactly what you are looking for and, unfortunately, I do not have an example.

    Please check the following documentation link to see if this suits your needs:
    https://docs.automic.com/documentation/webhelp/english/ALL/components/DU_AS/latest/%20%20Dollar%20Universe%20Guides/help.htm#ODBHelp/odb_jobuprocjobtypestoredprocsection.htm



  • 3.  Re: Dollar Universe running SQL

    Posted 03-07-2019 05:35 PM

    Thank you. This looks like it might be what I am looking for or at least get me close.