Thursday, May 28, 2020

OWA_UTIL textarea

Had an issue with passing data from a textarea in html to the backend. Kept getting buffer is small so had to use

owa_util.vc_arr.

while inserting text from a form we have the following options based on the number of characters.

1) VARCHAR2

2) declare a type in package and use it

TYPE Notes_Array_Type  IS TABLE OF VARCHAR2(2500) INDEX BY BINARY_INTEGER; 

posted_comments   Notes_Array_Type ;


3)owa_util.ident_arr  is table of varchar2(30) index by binary_integer;

4) owa_util.vc_arr is table of varchar2(32000) index by binary_integer;

 

No comments:

Post a Comment