I created a view to simplify the cursor within the package body. The SQL statement being used works as expected in SQL Developer but the program returns zero records. The program worked correctly before replacing one of the tables with this view. Not sure why all of a sudden the sql statement isn't returning anything. Do I have to grant rights to the view? Is there something I can do inside of the body to help me out? Thanks for any help in this matter...
February 10, 2009 2:44 PM
February 10, 2009 5:52 PM