odc
odc copied to clipboard
oceanbase
[Bug]: In oracle mode, only one row of ddl statements of type creation is displayed
ODC version
odc 424
OB version
not related
What happened?
In oracle mode, after the type is created successfully, you can click to view the ddl statement, and only one line is displayed. In fact, the ddl statement should not have only one line
What did you expect to happen?
When you click on the ddl of the View type, all statements are displayed
How can we reproduce it (as minimally and precisely as possible)?
-- Create the JSONTYPE using the following sql
CREATE OR REPLACE TYPE JsonType as object (
/* Variables */
json_data json_value_array,
check_for_duplicate number,
/* Constructors */
constructor function json return self as result,
constructor function json(str varchar2) return self as result,
constructor function json(str in clob) return self as result,
constructor function json(cast json_value) return self as result,
constructor function json(l in out nocopy json_list) return self as result,
/* Member setter methods */
member procedure remove(pair_name varchar2),
member procedure put(self in out nocopy json, pair_name varchar2, pair_value json_value, position pls_integer default null),
member procedure put(self in out nocopy json, pair_name varchar2, pair_value varchar2, position pls_integer default null),
member procedure put(self in out nocopy json, pair_name varchar2, pair_value number, position pls_integer default null),
member procedure put(self in out nocopy json, pair_name varchar2, pair_value boolean, position pls_integer default null),
member procedure check_duplicate(self in out nocopy json, v_set boolean),
member procedure remove_duplicates(self in out nocopy json),
/* deprecated putter use json_value */
member procedure put(self in out nocopy json, pair_name varchar2, pair_value json, position pls_integer default null),
member procedure put(self in out nocopy json, pair_name varchar2, pair_value json_list, position pls_integer default null),
/* Member getter methods */
member function count return number,
member function get(pair_name varchar2) return json_value,
member function get(position pls_integer) return json_value,
member function index_of(pair_name varchar2) return number,
member function exist(pair_name varchar2) return boolean,
/* Output methods */
member function to_char(spaces boolean default true, chars_per_line number default 0) return varchar2,
member procedure to_clob(self in json, buf in out nocopy clob, spaces boolean default false, chars_per_line number default 0, erase_clob boolean default true),
member procedure print(self in json, spaces boolean default true, chars_per_line number default 8192, jsonp varchar2 default null), --32512 is maximum
member procedure htp(self in json, spaces boolean default false, chars_per_line number default 0, jsonp varchar2 default null),
member function to_json_value return json_value,
/* json path */
member function path(json_path varchar2, base number default 1) return json_value,
/* json path_put */
member procedure path_put(self in out nocopy json, json_path varchar2, elem json_value, base number default 1),
member procedure path_put(self in out nocopy json, json_path varchar2, elem varchar2 , base number default 1),
member procedure path_put(self in out nocopy json, json_path varchar2, elem number , base number default 1),
member procedure path_put(self in out nocopy json, json_path varchar2, elem boolean , base number default 1),
member procedure path_put(self in out nocopy json, json_path varchar2, elem json_list , base number default 1),
member procedure path_put(self in out nocopy json, json_path varchar2, elem json , base number default 1),
/* json path_remove */
member procedure path_remove(self in out nocopy json, json_path varchar2, base number default 1),
/* map functions */
member function get_values return json_list,
member function get_keys return json_list
) not final;
Anything else we need to know?
No response
