Document Type | Troubleshooting
Category | Monitoring/Inspection
Applicable Product Version | 7FS02PS
Error Codes | 15146, 15163, 15002
Document Number | TMOTS006
Issue
When scheduling a job to execute the DBMS_JOB.SUBMIT procedure that runs the DBMS_MVIEW.REFRESH procedure in Tibero, the following errors may occur.
- JDBC-15146: PSM compilation error.
- TBR-15163: Unhandled exception at line 4.
- JDBC-15002: Parsing failed. at line 2, column 6 of null: jobno number;
Cause
The error occurs due to a syntax error (symbol_double quotation mark).
Solutions
Replace double quotation marks (โ) with two single quotation marks (โ โ) to indicate the string.
โSP_TESTโ, โCโ โ ''SP_TEST'',''C'โ
DECLARE
jobno number;
BEGIN
DBMS_JOB.SUBMIT(jobno, 'DBMS_MVIEW.REFRESH(''SP_TEST'',''C'');', sysdate, 'TRUNC(SYSDATE + 1) + 20/24');
END;
/