It's not a secret anymore!*
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
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
Similar Threads
set chained mode off ???
How to retrieve error messages of database into jsp page
Using CMP entity bean with stored procedure?
connection on exit
to use stored procedure or not