Simply i am using Report page.
On which there is one table which shows information.
Now i did put one Button in that region. By clicking that button all the Inforamtion must be inserted in to one another table in database.
what i did:
Created Button->DA->pl/sql expression-->
BEGIN
INSERT INTO oms_order_header(USER_ID, TOTAL_AMOUNT)
VALUES (1,1);
DBMS_OUTPUT.put_line (SQL%ROWCOUNT);
END;
-->ERROR--->
1 error has occurred
- ORA-06550: line 5, column 16: PLS-00103: Encountered the symbol "BEGIN" when expecting one of the following: ( - + case mod new not null <an identifier> <a double-quoted delimited-identifier> <a bind variable> continue avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date <a string literal with character set specification> <a number> <a single-quoted SQL string> pipe <an alternatively-quoted string literal with character set sp (Go to error)