Querying Block Based on Procedure

441275

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

441275

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

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.