2pack: column size for SQL statement shall be extended

Description

For a plugin I need to provide a database function. Its size is about 3000 characters. Even trying to 'compress' it by taking out comments leaves a size of about 2500 characters.

The column is currently of size memo and as implied by the description "limited to 2000 characters".

From a quick look into the sources it seems to me that all text type columns other than text long (which becomes a BLOB) are created as VARCHAR2. So my proposal is to keep it as memo and just extend it to 4000 chars.

WDYT?

Regards,

Dirk Niemeyer

Environment

None

Assignee

Hiep Lq

Reporter

Dirk Niemeyer

Labels

Tested By

None

Components

Affects versions

Priority

Major
Configure