Atlassian uses cookies to improve your browsing experience, perform analytics and research, and conduct advertising. Accept all cookies to indicate that you agree to our use of cookies on your device. Atlassian cookies and tracking notice, (opens new window)
Teams
, (opens new window)

Power Scripts for Jira Cloud
Results will update as you type.
  • Advanced features
  • Migration resources
  • Simple Issue Language
    • Getting started with SIL
    • SIL reference guide
    • SIL Functions library
      • Function Index
      • Packages
      • Array Functions
      • Basic Functions
      • Date and Interval Functions
      • Excel Functions
      • File Manipulation Functions
      • HTTP Functions
      • Incoming Mail Processing Functions
      • Integration with Other Systems
      • Jira Administration Functions
      • Jira Integration Functions
      • Jira Service Management Functions
      • Jira Software Functions
      • Listener Functions
      • Math Functions
      • Parameter Functions
      • Scheduling Functions
      • String Functions
      • System Integration
        • call
        • databaseAvailable
        • getPersistentVar
        • ldapUserAttr
        • ldapUserList
        • ldapUserRecord
        • ldapUserStruct
        • runSILInline
        • saveURLToFile
        • sendEmail
        • sendHtmlEmail
        • setPersistentVar
        • silEnv
        • sql
        • sqlCallStoredProcedure
        • sqlCallStoredProcedureWithOutParams
        • sysLock
        • sysSleep
        • sysUnlock
      • Webhooks Functions
  • Tutorials and recipes
  • Jira Product Discovery support
  • Release notes
  • Help and support
    You‘re viewing this with anonymous access, so some content might be blocked.
    /
    sqlCallStoredProcedure
    Updated Nov 19, 2024

    sqlCallStoredProcedure

    Description

    Executes the stored procedure over the defined datasource name / JNDI datasource.

    Parameters

    Return Type

    String []

    Examples

    Example 1

    Where showMessage() is a stored procedure existing in myDB database.

    string [] results = sqlCallStoredProcedure("myDB", "showMessage");

    Example 2

    Where addComponent(String id, String name) is a stored procedure existing in myDB database.

    string [] results = sqlCallStoredProcedure("myDB", "addComponent", "componentId", "componentName");

    To configure the data source, check the SQL data sources configuration chapter.

    See also

    • Page:
      sysLock
    • Page:
      sysSleep
    • Page:
      sysUnlock
    • Page:
      sendHtmlEmail
    • Page:
      call
    • Page:
      ldapUserAttr
    • Page:
      ldapUserList
    • Page:
      sql
    • Page:
      sqlCallStoredProcedureWithOutParams
    • Page:
      setPersistentVar
    • Page:
      sqlCallStoredProcedure
    • Page:
      saveURLToFile
    • Page:
      ldapUserStruct
    • Page:
      silEnv
    • Page:
      ldapUserRecord
    • Page:
      runSILInline
    • Page:
      databaseAvailable
    • Page:
      sendEmail
    • Page:
      getPersistentVar
    Peacock

    Need support? Create a request with our support team.

    Copyright © 2005 - 2025 Appfire | All rights reserved.

    {"serverDuration": 13, "requestCorrelationId": "2fad59ca736e4acda9f271e437e5fb51"}