ORA-06550: line 13, column 4: PLS-00103: Encountered the “UPDATE” ORA-06550: line 15, column 3: PLS-00103: Encountered the symbol “END”

by 
EXIT WHEN FLAG=1/*give some exit criteria here .You wrote update statement which was incorrect*/; 
--update table set counter=1 where counter is NULL;
-- LOOP until condition is met 
END LOOP;

More Related Contents:

  1. Can we use a parameter in a pl sql subprogram other than in where clause
  2. DBMS_OUTPUT.PUT_LINE not printing
  3. Create an Oracle function that returns a table
  4. Place to store PL/SQL block [closed]
  5. Splitting string into multiple rows in Oracle
  6. What is the string concatenation operator in Oracle?
  7. How to pass List from java to Oracle Procedure?
  8. PL/SQL – Use “List” Variable in Where In Clause
  9. How can you tell if a value is not numeric in Oracle?
  10. passing table and column name dynamically using bind variables
  11. SQL error “ORA-01722: invalid number”
  12. Create an Excel File (.xlsx) using PL/SQL
  13. How to send email using Oracle 10 g Forms
  14. SQL Fiddle Output Error
  15. oracle PL/SQL how to calculate range ip for IPv6 cidr
  16. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  17. How to split array list into equal parts?
  18. How to return multiple rows from the stored procedure? (Oracle PL/SQL)
  19. Execute multiple queries in single Oracle command in C#
  20. Oracle: how to INSERT if a row doesn’t exist
  21. Issue when comparing result of to_char(myDate, ‘DAY’) to a string
  22. Functions vs procedures in Oracle
  23. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  24. How to see refcursor result/output in Oracle SQL Developer? [duplicate]
  25. How to handle optional parameters in SQL query?
  26. How to use Alias in Where clause? [duplicate]
  27. How to check if a column exists before adding it to an existing table in PL/SQL?
  28. BEGIN – END block atomic transactions in PL/SQL
  29. How to handle a query with special characters / (forward slash) and \ (backslash)
  30. Using bind variables with dynamic SELECT INTO clause in PL/SQL

Leave a Comment