This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
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 OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Products » BEA/Weblogic
Bookmark "Problem with Stored Procedures" Watch "Problem with Stored Procedures" New topic
Author

Problem with Stored Procedures

Raghav Sam
Ranch Hand

Joined: Apr 12, 2001
Posts: 412
Hi

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: http://aspose.com/file-tools
 
subject: Problem with Stored Procedures