String length constraints must be in range (1 .. 32767)

The following error occurs during storage write:

I checked some network resources but did not solve the problem. Why do I always prompt that there is a problem with the String length? Clearly, the length of the input String is very short. Let's take a closer look, it is found that the stored procedure directly writes the varchar2 type in the defined string statement after the as. It is clear that the varchar2 length needs to be defined.

Write it as follows:

1 create or replace procedure Sp_SendMyEmail (v_From in varchar2, v_To in varchar2, v_Subject in varchar2, v_Body in varchar2) 2 as3 v_Cc varchar2 (20): = NULL; 4 v_Bcc varchar2 (20): = NULL;

 

No.