Hi All,
I try to execute this pl sql statemment, but i got error message: ORA-00904: "AUG": invalid identifier
How to format properly folowing statemment to avoid this error?
DECLARE
SQL_STM VARCHAR2(200);
D_END_TS DATE := TO_DATE (3000000, 'J');
V_UNAME TEST.OPA_ACCOUNTS.ACCOUNT_NAME%TYPE := 'OPS$TEST19';
BEGIN
sql_stm:='UPDATE TEST.OPA_ACCOUNTS SET END_TS = '||TO_DATE(SYSDATE, 'DD-MM-YYYY')||' WHERE ACCOUNT_NAME = '||V_UNAME||' AND END_TS = '||TO_DATE(SYSDATE, 'DD-MM-YYYY');
SYS.DBMS_OUTPUT.PUT_LINE(SQL_STM);
EXECUTE IMMEDIATE 'UPDATE TEST.OPA_ACCOUNTS SET END_TS = '||TO_DATE(SYSDATE, 'DD-MM-YYYY')||' WHERE ACCOUNT_NAME = '||V_UNAME||' AND END_TS = '||D_END_TS;
COMMIT;
END;
/
Table structure as follow:
| ACCOUNT_ID | NUMBER(10,0) | No | | 1 | |
| ACCOUNT_ENTRY_TS | DATE | No | | 2 | |
| CREATED_BY | VARCHAR2(30 BYTE) | No | | 3 | |
| ACCOUNT_NAME | VARCHAR2(30 BYTE) | No | | 4 | |
| INSTANCE_NAME | VARCHAR2(92 BYTE) | No | | 5 | |
| END_TS | DATE | No | | 6 | |
| FIRST_NAME | VARCHAR2(200 BYTE) | No | | 7 | |
| LAST_NAME | VARCHAR2(100 BYTE) | No | | 8 | |
| MODIFIED_BY | VARCHAR2(30 BYTE) | Yes | | 9 | |
| COMMENT_TEXT | VARCHAR2(200 BYTE) | Yes | | 10 | |