CODEWITHSUNDEEP
oracle-databasecheckboxplsqloracle-apex
user1680024
user1680024

Reputation: 1

How to get checkbox value in Oracle Apex application

I created the following pl/sql code in order to obtain the value of the checked row.

BEGIN
FOR I in 1..APEX_APPLICATION.G_F01.COUNT LOOP
 UPDATE TEST_CHECK_STATUS 
 SET check_status = 1
 WHERE rowid = APEX_APPLICATION.G_F02(APEX_APPLICATION.G_F01(I));
END LOOP;
END;

When execute this code i obtain this error:

ORA-06550: line 6, column 16: PLS-00103: Encountered the symbol "BEGIN" when expecting one of the following: ( - + case mod new not null continue avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date pipe

someone tell me where is the error?

Upvotes: 0

Views: 1571

Answers (1)

Thomas
Thomas

Reputation: 203

As already said, there is no syntax error in your statement. Did you really save your code block as PL/SQL anonymous block (not a block returning a boolean value and not a SQL block (!))?

Upvotes: 0

Related Questions