BN
parse is not helping
Size: a a a
2021 February 20
AV
parse is not helping
Of course if JSON spec is not normal, for example
APEX_JSON doesent work, but you can prepare you JSON to right format
{"foo","bar"}APEX_JSON doesent work, but you can prepare you JSON to right format
AV
DECLARE
j apex_json.t_values;
l_json_string varchar2(4000);
BEGIN
l_json_string := '{"foo","bar"}';
l_json_string := replace(l_json_string,'",','":0,');
l_json_string := replace(l_json_string,'"}','":0}');
dbms_output.put_line(l_json_string);
apex_json.parse(p_values => j,p_source => l_json_string);
dbms_output.put_line(apex_json.get_members(p_path=>'.',p_values=>j)(1)); -- foo
dbms_output.put_line(apex_json.get_members(p_path=>'.',p_values=>j)(2)); -- bar
END;
AV
This right way to send array of data:
DECLARE
l_json_string varchar2(4000);
l_count int;
v apex_json.t_value;
BEGIN
l_json_string := '{"data":["foo","bar"]}';
dbms_output.put_line(l_json_string);
apex_json.parse(p_source => l_json_string);
l_count := APEX_JSON.get_count(p_path => 'data');
DBMS_OUTPUT.put_line(' Count : ' || l_count);
FOR i IN 1 .. l_count LOOP
v := apex_json.get_value(p_path=>'data[%d]',p0=> i);
dbms_output.put_line(v.varchar2_value);
END LOOP;
END;
@
How about using Oracle sql json functions : json_value, json_table?
BN
Got it working by adding dummy key and then parse
BN
DECLARE
l_clob1 clob;
l_clob2 clob;
BEGIN
SELECT '{"wa":'||log_clob||'}'
INTO l_clob1
FROM app_log_tb
WHERE id = 3630;
-- 3648
apex_json.parse(p_source => l_clob1, p_strict => false);
l_clob2 := apex_json.GET_VARCHAR2 (p_path=>'wa');
dbms_output.put_line(apex_json.GET_VARCHAR2 (p_path=>'status'));
dbms_output.put_line(apex_json.GET_VARCHAR2 (p_path=>'message'));
END;
l_clob1 clob;
l_clob2 clob;
BEGIN
SELECT '{"wa":'||log_clob||'}'
INTO l_clob1
FROM app_log_tb
WHERE id = 3630;
-- 3648
apex_json.parse(p_source => l_clob1, p_strict => false);
l_clob2 := apex_json.GET_VARCHAR2 (p_path=>'wa');
dbms_output.put_line(apex_json.GET_VARCHAR2 (p_path=>'status'));
dbms_output.put_line(apex_json.GET_VARCHAR2 (p_path=>'message'));
END;
BN
it automatically unstringifyed
BN
Of course if JSON spec is not normal, for example
APEX_JSON doesent work, but you can prepare you JSON to right format
{"foo","bar"}APEX_JSON doesent work, but you can prepare you JSON to right format
This was the hint
BN
Of course if JSON spec is not normal, for example
APEX_JSON doesent work, but you can prepare you JSON to right format
{"foo","bar"}APEX_JSON doesent work, but you can prepare you JSON to right format
Thanks
AV
JSON API have very strong specification and string like this "{1,2,3}' - is not JSON and APEX_JSON can not parse this
https://jsonapi.org/format/
https://jsonapi.org/format/
BN
yeah the problem is that it is stringifyed..
AV
In start of 2000 we used own format for http :)
"first_row"|1|2|3]"second_row"|5|6|7]
2021 February 21
AL
What unfair?
b
I used plugin to get latitude and longitude
But it worked only when i used LOCALHOST or 127.0.0.1
If i used another ip to call the url from another pc it didn't work
Can anyone help me please?
But it worked only when i used LOCALHOST or 127.0.0.1
If i used another ip to call the url from another pc it didn't work
Can anyone help me please?
2021 February 22
RA
Hi
I want to implement document managemen.
What is the situation?
I want to implement document managemen.
What is the situation?
SP
beli
I used plugin to get latitude and longitude
But it worked only when i used LOCALHOST or 127.0.0.1
If i used another ip to call the url from another pc it didn't work
Can anyone help me please?
But it worked only when i used LOCALHOST or 127.0.0.1
If i used another ip to call the url from another pc it didn't work
Can anyone help me please?
SP
Note: As of Chrome 50, the Geolocation API will only work on secure contexts such as HTTPS. If your site is hosted on an non-secure origin (such as HTTP) the requests to get the users location will no longer function.
JK
You're the hero! Oracle would like to showcase the success of the Oracle APEX community, your success.
Announcing:
Real-World Low Code: APEX App of the Month
https://bit.ly/apex-app-of-the-month
Announcing:
Real-World Low Code: APEX App of the Month
https://bit.ly/apex-app-of-the-month
RP
did it work at 3 am?