Forum Stats

  • 3,817,316 Users
  • 2,259,310 Discussions
  • 7,893,746 Comments

Discussions

Querying Block Based on Procedure

441275
441275 Member Posts: 9
edited Sep 23, 2009 5:36PM in Forms
I built the form based off the following thread:

622576

However, the block created by the procedure does not appear to be queryable with any given criteria. Query Enter, enter criteria, Query Execute didn't work it still returns the all the data. I also tried putting in a default where clause, but that didn't work. Is there a way to query the result set returned?

Thanks,
Roschera
Tagged:

Answers

  • 441275
    441275 Member Posts: 9
    Okay, now I've tried adding data source arguments to pass in a parameter to the cursor being used to generate the data. I've set the default value to null and double checked to make sure the same data types are being used, however, I'm still receiving an ORA-6502 error. Any help would be appreciated.

    Thanks,
    Roschera
  • 441275
    441275 Member Posts: 9
    I found the above way is the how to query a block built by a procedure. The ORA-6502 error was caused by an error in the procedure itself not in the form.
This discussion has been closed.