You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

string literal longer than 32767 bytes.

Accepted answer
16
Views
1
Comments

Summary: Hi Team

I am trying to load JSON File content into DB table, but my block is throwing me an error as "string literal too long."


set define off;

DECLARE

  v_json_data clob := '{Json File Content which is more than 32676 char}';

BEGIN

NULL;

  insert into Test_Table (JSON_FILE_CONTENT)values( v_json_data);

END;

/

Content (required):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!