This week's book giveaway is in the Agile forum.
We're giving away four copies of The Software Craftsman and have Sandro Mancuso 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 The Software Craftsman this week in the Agile 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