Maximo Open Forum

 View Only
  • 1.  Pl Sql using in dbc maximo

    Posted 06-03-2021 07:41
    Edited by Sahil Dutta 06-03-2021 07:42
    Hi All,

    how to run pl sql using in dbc scripts maximo
    #EverythingMaximo

    ------------------------------
    Sahil Dutta
    xyz
    ------------------------------


  • 2.  RE: Pl Sql using in dbc maximo

    Posted 06-04-2021 08:44
    You are able to execute standard SQL statements you want with something like:

    <freeform description="What I'm trying to do in the DBC file">
        <sql>update mytable set value1='literalvalue';</sql>
    </freeform>

    When you say PL/SQL, that technically covers all the Oracle syntax but some people refer to it specifically around procedures and such. I've never tried to utilize it to define a procedure, but you definitely would be able to invoke a procedure if it already existed. I assume you've had issues defining the procedures in the DBC file?

    ------------------------------
    Steven Shull
    Projetech Inc.
    ------------------------------



  • 3.  RE: Pl Sql using in dbc maximo

    Posted 06-04-2021 09:06
    Yes we would like to define and execute procedure through DBC instead of directly applying to database.​

    ------------------------------
    Sahil Dutta
    xyz
    ------------------------------