Questions on Stored Procedures 
Author Message
 Questions on Stored Procedures
Can anyone help me to answer these questions on stored procedures:

1.  Can you have a nested SPs?  One SP calling another SP.

2.  Can you access another database from a SP?

Any feedback is welcomed.

Regards.



Sat, 24 Aug 2002 03:00:00 GMT
 Questions on Stored Procedures

Raha,

1. Yes if your SP's are Java.  You merely instantiate the class and
invoke it's methods (i.e. a JAVA SP is only a class with methods) from
within your SP you are running.

2. Haven't tried.

Andrew

Quote:

> Can anyone help me to answer these questions on stored procedures:

> 1.  Can you have a nested SPs?  One SP calling another SP.

> 2.  Can you access another database from a SP?

> Any feedback is welcomed.

> Regards.



Sat, 24 Aug 2002 03:00:00 GMT
 Questions on Stored Procedures

Raha,

If you need examples for JAVA I can provide them.

Andrew

Quote:

> Raha,

> 1. Yes if your SP's are Java.  You merely instantiate the class and
> invoke it's methods (i.e. a JAVA SP is only a class with methods) from
> within your SP you are running.

> 2. Haven't tried.

> Andrew


> > Can anyone help me to answer these questions on stored procedures:

> > 1.  Can you have a nested SPs?  One SP calling another SP.

> > 2.  Can you access another database from a SP?

> > Any feedback is welcomed.

> > Regards.



Sat, 24 Aug 2002 03:00:00 GMT
 Questions on Stored Procedures
  I'm having some stored procedure troubles as well.
I have written an SP that doen't load... I get an error/Exception about
unable to load Java Class error "1".
 Sorry I don't have the exact error text, I'm having some problems with
reading news at work..

 Also, is there a way to force a reload of a class. When you
"Create" the Proc the JVM doesn't reload the class.
(Class output should have changed...)

Some more indepth samples would be nice.
  Any help or pointers would be appriciated.
    JR

JR Andreassen

Quote:
> Raha,
> If you need examples for JAVA I can provide them.
> Andrew


> > Raha,
> > 1. Yes if your SP's are Java.  You merely instantiate the class and
> > invoke it's methods (i.e. a JAVA SP is only a class with methods) from
> > within your SP you are running.

> > 2. Haven't tried.

> > > Can anyone help me to answer these questions on stored procedures:
> > > 1.  Can you have a nested SPs?  One SP calling another SP.
> > > 2.  Can you access another database from a SP?
> > > Any feedback is welcomed.



Mon, 26 Aug 2002 03:00:00 GMT
 Questions on Stored Procedures

 Here is the actual Exception :
COM.ibm.db2.jdbc.app.DB2Exception:
[IBM][CLI Driver][DB2/NT] SQL4304N
Java stored procedure or user-defined function "KEYGEN  .SP_GET_KEY",
specific name "SQL000309172814820" could not load Java class
"com/dbwiz/db2/sp/KeyAlloc", reason code "1".  SQLSTATE=42724

Quote:
>   I'm having some stored procedure troubles as well.
> I have written an SP that doen't load... I get an error/Exception about
> unable to load Java Class error "1".
>  Sorry I don't have the exact error text, I'm having some problems with
> reading news at work..

>  Also, is there a way to force a reload of a class. When you
> "Create" the Proc the JVM doesn't reload the class.
> (Class output should have changed...)

> Some more indepth samples would be nice.
>   Any help or pointers would be appriciated.
>     JR

> JR Andreassen

> > Raha,
> > If you need examples for JAVA I can provide them.
> > Andrew


> > > Raha,
> > > 1. Yes if your SP's are Java.  You merely instantiate the class and
> > > invoke it's methods (i.e. a JAVA SP is only a class with methods) from
> > > within your SP you are running.

> > > 2. Haven't tried.

> > > > Can anyone help me to answer these questions on stored procedures:
> > > > 1.  Can you have a nested SPs?  One SP calling another SP.
> > > > 2.  Can you access another database from a SP?
> > > > Any feedback is welcomed.



Mon, 26 Aug 2002 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. A simple question on Stored procedure with parameter

2. Newbie question on stored Procedures and triggers.

3. CreateTable Format Question in Stored Procedure

4. Basic Question about stored procedures

5. Question: Debugging Stored Procedures via Visual Studio

6. Questions about Store Procedure

7. Newbie Question about stored procedures.

8. rookie question about stored procedures

9. Simple Join Question and Stored Procedure

10. Newbie question on Stored Procedure

11. A simple Question About Store Procedure

12. Metaphysical questions about stored procedure utilization


 
Powered by phpBB® Forum Software