Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    1

    Unanswered: How Can I Call A Java StoredProcedure In A SQL StoredProcedure ?

    I Have Two Procedures.
    One is Writen by Java.
    Another is writen by SQL.
    I want to call the Java Procedure in the SQL Procedure.

    Error Message:
    [IBM][CLI Driver][DB2/SUN] SQL0751N User defined function or procedure "" (specific name "") attempted to execute a statement that is not allowed. SQLSTATE=00000

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: How Can I Call A Java StoredProcedure In A SQL StoredProcedure ?

    The following link in Appl. development guide details restrictions on nesting stored procedures.

    http://www-3.ibm.com/software/data/d...3.htm#storproc

    HTH

    Sathyaram

    Originally posted by iampawpaw
    I Have Two Procedures.
    One is Writen by Java.
    Another is writen by SQL.
    I want to call the Java Procedure in the SQL Procedure.

    Error Message:
    [IBM][CLI Driver][DB2/SUN] SQL0751N User defined function or procedure "" (specific name "") attempted to execute a statement that is not allowed. SQLSTATE=00000

  3. #3
    Join Date
    Aug 2002
    Posts
    35

    Re: How Can I Call A Java StoredProcedure In A SQL StoredProcedure ?

    You have the define the stored proceure as Nested to do that.

    From,
    vasu,
    Tech Architect








    Originally posted by sathyaram_s
    The following link in Appl. development guide details restrictions on nesting stored procedures.

    http://www-3.ibm.com/software/data/d...3.htm#storproc

    HTH

    Sathyaram
    vasu

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •