Oracle Application Express (APEX)


report error: ORA-20001: Error fetching column value: ORA-01403: no data found ORA-06510: PL/SQL: unhandled user-defined exception


Hi ,I created validation for my tabular form. DECLARE   lv_v_pusers   VARCHAR2 (50);   lv_v_susers   VARCHAR2 (50);   lv_n_count    NUMBER        := 0;BEGIN   FOR i IN 1 .. apex_application.g_f03.COUNT   LOOP      IF apex_application.g_f03 = 'Lead Programmer'      THEN         lv_v_pusers := apex_application.g_f06 (i);      ELSIF apex_application.g_f03 = 'Lead Statistician'      THEN         lv_v_susers := apex_application.g_f06 (i);      END IF;        FOR p_users IN (SELECT     REGEXP_SUBSTR (lv_v_pusers,                                                '[^:]+',                                                1,                                                LEVEL                                               ) users                            FROM DUAL                      CONNECT BY REGEXP_SUBSTR (lv_v_pusers, '[^:]+', 1,                                                LEVEL) IS NOT NULL)      LOOP         FOR s_users IN (SELECT     REGEXP_SUBSTR (lv_v_susers,                                                   '[^:]+',                                                   1,                                                   LEVEL                                                  ) users                               FROM DUAL                         CONNECT BY REGEXP_SUBSTR (lv_v_susers,                                                   '[^:]+',                                                   1,                                                   LEVEL                                                  ) IS NOT NULL)         LOOP            IF p_users.users = s_users.users            THEN               lv_n_count := 1;            END IF;         END LOOP;      END LOOP;   END LOOP;   IF lv_n_count = 1   THEN      RETURN 'Programmer and Reviewer cannot be same' || lv_n_count;   END IF;END; And whenever the validation  occurs Iam getting this error: report error: ORA-20001: Error fetching column value: ORA-01403: no data found ORA-06510: PL/SQL: unhandled user-defined exception Any Idea how to overcome the issue? Iam using APEX 5, Universal Theme.  Thanks & Regards,Nivetha.
Nivetha, It seems like you could just use the built in row level validation instead.  Create a new validation with the following attributes:Tabular Form = Name of your formValidation Level = Tabular Form RowValidation Type = PL/SQL Expression or Function Returning BooleanValidation Code = 
:PROGRAMMER_COLNAME != :REVIEWER_COLNAME
 Here's the documentation for more clarification:https://docs.oracle.com/database/121/HTMDB/bldr_validate.htm#HTMDB28941 Hope this helps,Paul
btw, you can also refer to other column values in your row to use in your error message using the &. syntax.  For example, error message is: For &DEPTNAME_COL. the Programmer cannot be the same as Reviewer 
Hi Pmon, Thanx for the reply, but my problem is Iam not using MRU for tabular form instead Iam using Manual Process. So I can't create Tabular Form Validation without MRU.
Sorry, I see your problem.  In this blog it says that the error occurs because "the referenced array does not exist" http://deneskubicek.blogspot.com/2012/06/apex-tabular-form-and-ora-01403-no-data.html He even gives tips on how to debug the issue.  Hope this helps,Paul
Thanks Paul, I will try that method

Related Links

apex.oracle.com
PAGE BLINK INTERMITTENT
Selectable columns on report
Trying to import Amazon example amazonstore_1.6.sql script
Express Database edition
Passing Session Values to the Tabular Form Element of a Report Column
Report
How to disable "deep linking" feature?
Master Detail User Interface Defaults
How to create a blank page template?
Monitoring mail queue
Parsing Error
Is APEX aslo licence free on a production server?
EDIT Link with Stored Procedure
htmldb line chart problem
Errors in Firefox

Categories

ORACLE DEV
Fusion Middleware
Oracle Call Interface ...
E-Business Suite Archi...
Human Capital Manageme...
Calendar
RAC, ASM & Clusterware...
EBS on Linux
XQuery
On Demand: SaaS and Ma...
Berkeley DB XML
OC4J (Korean)
Performance Tuning (Ko...
SQL Developer (Korean)
WebCenter Portal
XML Gateway (Korean)
Essbase
Retail
SOA Suite and OC4J 11g...
LCM: Oracle iSetup
JRockit
Transaction Processing
Oracle on Amazon Web S...
weblogic.developer.int...
WebLogic Server/Java E...
weblogic.developer.int...
weblogic.developer.int...
BEA Tuxedo 10.0 Beta
aqualogic.bpm.general
aqualogic.bpm.modeling
Primavera Systems Tech...
存档论坛
小憩一会
EJB Development (Chinese)
Designer (Korean)
Sun Java Studio Creator
Forums Moderator Migra...
Java APIs
Java Essentials
Java Security
Reflections & Referenc...
Application Development
Java ME SDK
Internationalization (...
Abstract Window Toolki...
Accessibility
Java System Portal Ser...
Java System Mobile Ent...
Sun ONE Integration Se...
Oracle Developer Suite...
NoSQL Database
PHP (Korean)
Endeca Experience Mana...
WebCenter Sites
Oracle Application Ser...
Siebel (Chinese)
Peoplesoft应用产品
Webservice(SOA) (Korean)
JD Edwards (Chinese)
Daily Notifications
Oracle PartnerNetwork ...
Software-as-a-Service
Discuss
Bulk API
E10
Switzerland Eloqua Use...
Pharma, Life Sciences,...
SRM/Eloqua users
Computershare
Darios Sonera group
Insurance
Modern Supply Chain Ex...
Supply and Demand
OTN Summit Middleware ...
Español
Oracle Academy - Commu...
Oracle Applications Us...
OBIEE12C
Accelerating Startups
E-Business Suite on Or...
JavaScript - Nashorn
Cloud Accelerate
Microservices
Romanian Oracle User G...
HrOUG
Cúpula Virtual de Tecn...
Brazil - Eloqua User G...
Database Application D...
SQL and PL/SQL
Database and Applicati...
XML DB
Business Intelligence ...
Application Server (Ko...
JD Edwards World Gener...
weblogic.developer.int...
Identity Services
Patterns & OO Design
Solaris Archived Forums
Big Data Connectors/Ha...
Oracle Java Cloud Service
OTN ArchBeat Podcast
Demand Management

Resources

Encrypt Message



code
soft
python
ios
c
html
jquery
cloud
mobile