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
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?