PL/SQL (MOSC)

MOSC Banner

PLS-00307 when using json type

in PL/SQL (MOSC) 4 commentsAnswered ✓

The below returns error PLS-00307 on line 9 column 3.

Our DB is 18.11. Can you help?


DECLARE

 jo JSON_OBJECT_T;

BEGIN

 jo := NEW JSON_OBJECT_T;

 jo.put('number',  1);          

  jo.put('string',  'abc');

 jo.put('date',    SYSDATE);

 jo.put('datetime', to_timestamp(SYSDATE));

 jo.put('datetime', systimestamp);

END;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center