File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem with Stored Procedures

 
Raghav Sam
Ranch Hand
Posts: 412
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Karthik Guru
Ranch Hand
Posts: 1209
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic