SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using Views in PL/SQL Cursors

martinleyMar 27 2009 — edited Mar 27 2009

Hi,

I have created a Cursor that uses the per_assignments_v5 view, when running the standalone query in Toad it returns the correct data.

When I try and put this into a cursor (I have run in both the application and in TOAD) it returns no rows.

Can anyone help me with this issue?

Many thanks

Martin

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 24 2009

Added on Mar 27 2009

8 comments

1,456 views