stored procedure

stored procedure

Post by J » Fri, 23 May 2003 17:13:44



How can I call a SQL stored procedure with an OUT parameter from a db2
script and retrieve the output value?
Thanks.
 
 
 

1. Calling a Java Stored Procedure from another Java Stored Stored Procedure

Hi,
I'm using the stored procedure builder of DB2 UDB v6.1 on NT to create a
Java Stored Procedure to call another Java Stored Procedure. Both of
them belong to the same project in stored procedure builder.
The sp that calls another sp has the code as follows:
// Calling another java sp -- ErrorHandler
ErrorHandler err = new ErrorHandler();
err.execute("Test #1", 100, "Testing #1");
When I want to build the sp which calls another sp from within, it gave
me an error as follows:
C:\IBMVJava\ide\tools\com-ibm-db2-tools-dev-spb-ivj\spb\bld953747549650\
com\intertrac\datamart\sp\SelectBillShipAddr.java:18: Class
com.intertrac.datamart.sp.ErrorHandler not found in type declaration.
ErrorHandler err = new ErrorHandler();
Does anyone have any clue of how this can be properly done ? Please let
me know.
Thanks,
ra

Sent via Deja.com http://www.deja.com/
Before you buy.

2. HELP !!!!

3. Stored Procedure calling Stored Procedure

4. MSDE and delphi experiences ?

5. Executing a Stored Procedure in a Stored Procedure and selecting on the result

6. ADO/OLE DB Somtimes always use Variants

7. Call a stored procedure from another stored procedure

8. a couple questions

9. Calling a stored procedure with parameters from another stored procedure

10. using SQL stored procedure results in stored procedure

11. Using Resultset in Stored Procedure in another stored procedure

12. Stored Procedure using another Stored Procedure

13. Calling a Stored Procedure from a Stored Procedure