ApexLib - The Oracle APEX Framework / Discussion / Open Discussion: select rows on tabular form problem

Patrick,

I have successfully used this in the past but I am having trouble with my current task. When I do a process to grab the selected rows I get the ORA-01403: No data found error.

ORA-01403: no data found ORA-01403: no data found
ORA-01403: no data found ORA-01403: no data found

Below my comments I have included some of the debug listing from the page when I get the error. More information... The "report" is an updateable report but with no really changeable fields (a few have display as text save state, the rest I think are standard report columns).

Ideas?

Thanks,
Steve

p.s. on the pulled report thing - it was a mixture of apexlib and javascript from Carl and Carl gave me a way to handle it (I posted the solution on the Forum).

Get column list(ApexLib_Sql.getColumnList)
...parse query = select "SAP_SUMMARY_ID" clink, "SAP_SUMMARY_ID", "SAP_ID", "MATRIX", "NUMBER_OF_SAMPLES", "CONTAINER_SIZE", "CONTAINERS_PER_SAMPLE", "CONTAINER_TYPE", "PRESERVATIVE_REQUIREMENT", "SAMPLE_TYPE", "SAMPLE_ARCHIVE_REQUIREMENT", "ANALYTICAL_SUPPORT_LEVEL", "VALIDATION_SUPPORT_LEVEL", "SAMPLE_DISPOSITION", "REPORTING_BASIS", "COMMENTS", "D_ADDED", "ANALYTICAL_METHOD_ID", "UNIT_PRICE", "TURNAROUND_TIME_DAYS", "SOW_ID", "SAMPLE_FREQUENCY", "STATION_NAME", "HOLDING_TIME" from "CAS"."SAP_SUMMARY" where sap_id = :P19_SAP_ID
......column CLINK not mapped - not stateful.
......column SAP_SUMMARY_ID mapped to WWV_Flow.g_f02
......column SAP_ID mapped to WWV_Flow.g_f03
......column MATRIX not mapped - not stateful.
......column NUMBER_OF_SAMPLES not mapped - not stateful.
......column CONTAINER_SIZE not mapped - not stateful.
......column CONTAINERS_PER_SAMPLE not mapped - not stateful.
......column CONTAINER_TYPE not mapped - not stateful.
......column PRESERVATIVE_REQUIREMENT not mapped - not stateful.
......column SAMPLE_TYPE not mapped - not stateful.
......column SAMPLE_ARCHIVE_REQUIREMENT not mapped - not stateful.
......column ANALYTICAL_SUPPORT_LEVEL not mapped - not stateful.
......column VALIDATION_SUPPORT_LEVEL not mapped - not stateful.
......column SAMPLE_DISPOSITION not mapped - not stateful.
......column REPORTING_BASIS not mapped - not stateful.
......column COMMENTS not mapped - not stateful.
......column D_ADDED not mapped - not stateful.
......column ANALYTICAL_METHOD_ID mapped to WWV_Flow.g_f04
......column UNIT_PRICE not mapped - not stateful.
......column TURNAROUND_TIME_DAYS not mapped - not stateful.
......column SOW_ID not mapped - not stateful.
......column SAMPLE_FREQUENCY not mapped - not stateful.
......column STATION_NAME not mapped - not stateful.
......column HOLDING_TIME not mapped - not stateful.
...array has 3 row(s). Used f04 to count.
...done
Validate report columns(ApexLib_TabForm.validateColumns)
Row 1 has checksum error. ORA-01403: no data found ORA-01403: no data found ORA-01403: no data found
...Row 1
...SAP_SUMMARY_ID
0.01: A C C E P T: Request="SUBMIT"
0.01: Metadata: Fetch application definition and shortcuts
0.01: alter session set nls_language="AMERICAN"
0.01: alter session set nls_territory="AMERICA"
0.02: ...NLS: Set Decimal separator="."
0.02: ...NLS: Set NLS Group separator=","
0.02: ...NLS: Set date format="DD-MON-RR"
0.02: ...Setting session time_zone to -04:00
0.02: Fetch session state from database
0.03: ...Check session 1022975405394868 owner
0.03: ...Metadata: Fetch Page, Computation, Process, and Branch
0.03: Session: Fetch session header information
0.03: ...Metadata: Fetch page attributes for application 104, page 19
0.04: ...Check authorization security schemes
0.04: Session State: Save form items and p_arg_values
0.04: ...Session State: Save "P19_SAP_ID" - saving same value: "54"
0.04: ...Session State: Save "P19_COLUMNS" - saving same value: ""
0.04: ...Session State: Save "P19_VIEWONLY" - saving same value: ""
0.04: ...Session State: Save "P19_SOW_ID" - saving same value: "7"
0.04: Processing point: ON_SUBMIT_BEFORE_COMPUTATION
0.04: ...Process "ApexLib-Before Computation/Validation": PLSQL (ON_SUBMIT_BEFORE_COMPUTATION) BEGIN ApexLib_Lov.clearLovNullValues; -- ApexLib_Item.validateItems; ApexLib_TabForm.validateColumns; -- ApexLib_Error.showErrorStack; END;
0.06: Encountered unhandled exception in process type PLSQL
0.06: Show ERROR page...
0.06: Performing rollback...

select rows on tabular form problem

Forums

Help

select rows on tabular form problem

select rows on tabular form problem

Forums

Help

select rows on tabular form problem document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

select rows on tabular form problem