Gettting SQL0751N trying to call java stored procedure from a java stored procedure

Gettting SQL0751N trying to call java stored procedure from a java stored procedure

Post by Tamm » Sun, 07 Apr 2002 07:41:39



I am trying to call a java stored procedure from a java stored
procedure.

I am getting the following error.

[IBM][CLI Driver][DB2/NT] SQL0751N  User defined function or procedure
"" (specific name "") attempted to execute a statement that is not
allowed.

Thanks
Tammy

 
 
 

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. ? How to pass parameters from form to form

3. Calling Java Stored Procedure from SQL Stored Procedure

4. 3rd party memory

5. Calling Java code on disc from a Java Stored Procedure

6. Why does Oracle need this Index ?

7. ---JAVA-----JAVA-----JAVA-----JAVA-----JAVA-----JAVA-----JAVA-----JAVA---

8. OLE DB Templates

9. Call SQL Loader from a java stored procedure

10. Error ORA-00932 when calling Java Stored Procedure

11. Calling a Stored Procedure from Java Code

12. HELP - Stored Procedure(Function) call through java to Informix database

13. calling SQL Server stored procedure from Java