Calling Stored procedure from inside Birt Maximo

Vineet Joshi
Vineet Joshi
edited February 11, 2022 in Analytics #1
Hi All ,

Please tell me the steps to call a stored procedure(in oracle) through birt(from inside maximo).
Also ,how to make report run for maximo default where clause(1=1) in case of stored procedure.


Regards

Comments

  • jverly01
    jverly01
    edited December 31, 1969 #2
    Can you give a little more detail on what the stored procedure does or what you need it do when the report is run?
  • Vineet Joshi
    Vineet Joshi
    edited December 31, 1969 #3
    <blockquote class='ipsBlockquote' data-author="'jverly01'" data-cid="115012" data-time="1363124751" data-date="12 March 2013 - 02:45 PM"><p>
    Can you give a little more detail on what the stored procedure does or what you need it do when the report is run?<br /></p></blockquote>
    <br />
    Hi ,<br />
    <br />
    Sorry for replying late as i was busy with other stuffs .Let me rephrase<br />
    <br />
    I have a List report which runs from application (Ex -WoPrint Report). we select Site ,Status in application only and this is passed to Report(Which has a Stored Procedure in back end) .<br />
    Can you please help me with an Example .Also ,let me know if i am still not clear <br />
    <br />
    <strong class='bbc'>Regards</strong>
  • micajblock
    micajblock E
    edited December 31, 1969 #4
    Thank you jverly01 for pointing me to this link.

    https://www.ibm.com/developerworks/community/blogs/a9ba1efe-b731-4317-9724-a181d6155e3a/entry/stored_procedures_and_maximo_reporting6?lang=en

Categories

image
OpenText CE Products
Magellan Text Mining
Docs & APIs