RAISE_APPLICATION_ERROR(-20001, 'This is a custom error message.'); END; 在“Error Handling”(错误处理)部分,可以选择定义函数的错误处理方式。您可以选择使用默认的错误处理方式,或者自定义错误处理逻辑。 点击“Next”(下一步)按钮,然后根据需要配置函数的参数和返回值。 点击“Create”(创建)按钮,完成函数...
动态操作完美地执行,生成交互式报告,包括raise_application_error(如果发生)。但我的问题是,raise_application_error并不是显示用户友好的消息,而是通过动态操作(使用pl/sql代码)正确显示错误消息的任何其他方式。我 浏览11提问于2015-12-24得票数 0 回答已采纳 1回答 动态隐藏/显示交互式报表中的列(Oracle APEX 5.1...
raise_application_error(-20987,'No records found'); end if; EXCEPTION WHEN OTHERS THEN :status := 400; l_result := 'Something went wrong while processing...'; END; APEX_UTIL.PRN (l_result, FALSE); END; 在Oracle APEXSQL 工作室 -> SQL 命令中執行下列動作,以建立執行從 Oracle Autonomous...
(l_sql, p_refcursor, l_result); if l_result is not null then :status := 200; else raise_application_error(-20987,'No records found'); end if; EXCEPTION WHEN OTHERS THEN :status := 400; l_result := 'Something went wrong while processing...'; END; APEX_UTIL.PRN (l_result, ...
RAISE_APPLICATION_ERROR(-20000, 'Invalid username/password.'); END; FUNCTION valid_user (p_username IN VARCHAR2, p_password IN VARCHAR2) RETURN BOOLEAN AS BEGIN valid_user(p_username, p_password); RETURN TRUE; EXCEPTION WHEN OTHERS THEN ...
只要它可以用于调试目的，用户很可能不会使用我前面提到的任何工具。如果它是Oracle Forms应用程序或Apex...
CASE v('APEX$ROW_STATUS') WHEN 'C' THEN r := VENUES$TAPI.ins (rv => rv); WHEN 'U' THEN r := VENUES$TAPI.upd (rv => rv); ELSE NULL; END CASE; END IF; log_end; EXCEPTION WHEN UTIL.application_error THEN log_end('application_error'); RAISE; WHEN OTHERS THEN UTIL...
RAISE_APPLICATION_ERROR(-20000, 'Upload failed - ' || APEX_WEB_SERVICE.G_STATUS_CODE); END IF; END UPLOAD_FILE; Configuring the Automatic Row Processing to Insert a New Record into the Table Once the file has been uploaded to the object storage and the relevant value...
$ sqlplus /nolog @myScript.sql connect myUser/myPwd@myTnsAlias spool myScript.log; declare v_script varchar2(128); begin v_script := 'myScript.sql'; doSomething; exception when others then logger.log_error ('Error in Script '||v_script); raise; end; / spool off; The example shows...
30520385 - INTERACTIVE GRID DML PROCESS WITH CUSTOM PL/SQL CODE USING :ROWID ERRORS OUT WITH "STOP APEX ENGINE" If a custom PL/SQL process, which uses the :ROWID alias, is used for a page process related to an Interactive Grid region, then it will raise an error when executed. Upon ...