File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes BEA/Weblogic and the fly likes Problem with Stored Procedures Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "Problem with Stored Procedures" Watch "Problem with Stored Procedures" New topic

Problem with Stored Procedures

Raghav Sam
Ranch Hand

Joined: Apr 12, 2001
Posts: 412

I have a web-based application where I use Stored Procedures. I make changes to the SP and compile it from the back-end. I then access the SP through my front-end. It gives oracle error 6508 - "could not find the program unit being called". I then need to restart my server before I can access the SP. How do I this without restarting the server. I am using Weblogic 6.1.

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind.<br />- Dr. Seuss
Karthik Guru
Ranch Hand

Joined: Mar 06, 2001
Posts: 1209
Dont think you need to restart weblogic. Couple of basic questions:

Does the SP compile properly?. Hopefully oracle does not throw up errors while compiling. The connection parameters (userid/password) supplied in weblogic connection pool represents the schema where the SP resides?
I agree. Here's the link:
subject: Problem with Stored Procedures
It's not a secret anymore!