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