SQL Developer Views and Programs

70 pts.
Tags:
AS/400 SQL View
SQL Developer
SQL development
SQL statements
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...
ASKED: February 10, 2009  2:44 PM
UPDATED: February 10, 2009  5:52 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

What language is your program in?

—–

Are you connecting to the database with the same user as when you run the package from sql developer ?

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Petpat123
    I believe I caught the problem. It is working now in the program as well. I was passing a lot of parameters to the select through the cursor and fat-fingered a bad letter on one of them. This is a large program and finally the error caught my eye. Thanks for the help though.....
    70 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following