标识符'APEX_JSON.PARSE'必须在oracle 11.2.0中声明 [英] Identifier 'APEX_JSON.PARSE' must be declared in oracle 11.2.0
本文介绍了标识符'APEX_JSON.PARSE'必须在oracle 11.2.0中声明的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想在 Oracle数据库11g企业版11.2.0.4.0-64位生产版本 中解析JSON.但下面报告了错误:
I want to parse JSON in Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production. But below error reported:
ORA-06550: line 4, column 5:
PLS-00201: identifier 'APEX_JSON.PARSE' must be declared
这是我的示例代码:
DECLARE
s varchar2(32767) := '{ "a": 1, "b": ["hello", "world"]}';
BEGIN
apex_json.parse(s);
sys.dbms_output.put_line('a is '||apex_json.get_varchar2(p_path => 'a'));
END;
此版本支持此功能吗?
推荐答案
这取决于数据库中的APEX版本,我猜在您的11.2实例上仍可能是4.x.
This depends on the APEX version within your database, which I'm guessing may still be 4.x on your 11.2 instance.
SELECT VERSION_NO FROM APEX_RELEASE;
apex_json软件包是从5.0引入的 http://docs.oracle.com/cd/E59726_01/doc.50/e39149/apex_json.htm#AEAPI29635
The apex_json package was introduced with 5.0 http://docs.oracle.com/cd/E59726_01/doc.50/e39149/apex_json.htm#AEAPI29635
这篇关于标识符'APEX_JSON.PARSE'必须在oracle 11.2.0中声明的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文