How can i save dual table data into a table by Interactive Grid?
Example:
SELECT NULL AS DEPARTMENT_ID,NULL AS DEPARTMENT_NAME FROM DUAL
I Want to insert it in Department Table.
Select department_id,department_name from department.
ShimulProfessional
afzal
PROCESS- INTERACTIVE GRIDE AUTOMATIC ROW PROCESSING(DML)
TARGET TYPE- PL/SQL CODE
BEGIN
CASE :APEX$ROW_STATUS
WHEN 'C' THEN
INSERT INTO Department
(department_id,department_name)
VALUES
(:DEPARTMENT_ID,:DEPARTMENT_NAME)
END CASE;
END;
Shimul
BEGIN
CASE :APEX$ROW_STATUS
WHEN 'C' THEN
INSERT INTO Departments
(department_id,department_name)
VALUES
(DEPARTMENTS_SEQ.nextval,:DEPARTMENT_NAME);
END CASE;
END;
ORA-06592: CASE not found while executing CASE statement
Vinish Kapoor
Case syntax is not correct, it should be as follows CASE WHEN :APEX$ROW_STATUS = 'C' THEN. You can use IF instead of CASE:
Shimul
Error: ORA-01732: data manipulation operation not legal on this view