Announcement

Collapse
No announcement yet.

Stored Procedure Source Tab

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Stored Procedure Source Tab

    Hi all!

    I'm trying to execute a stored procedure in the source tab.
    My procedure is going to return a result set like a query "SELECT * FROM TABLE_NAME". The problem is how to retrieve the fields from the stored procedure?

    Follow below the code

    ================================================
    var dbConn = DatabaseConnectionFactory.createDatabaseConnection ('net.sourceforge.jtds.jdbc.Driver','jdbc:jtdsqlse rver://server_name:9999/database_name','user','password');
    var result = dbConn.executeCachedQuery("EXEC PROCEDURE_NAME");

    dbConn.close();

    return result;
    ================================================

    Should I create filter to capture the result set? How can I implement that?

    Thanks!

    Alexander
Working...
X