Maximo Open Forum

Expand all | Collapse all

Pl Sql using in dbc maximo

  • 1.  Pl Sql using in dbc maximo

    Posted 9 days ago
    Hi All,

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

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


  • 2.  RE: Pl Sql using in dbc maximo

    Maximo Certified
    Posted 8 days ago
    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 8 days ago
    Yes we would like to define and execute procedure through DBC instead of directly applying to database.​

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