[Gusdev-gusdev] Core.AlgorithmParam: Another column size problem

[<ju...@cs...>]

While recently working with one of our locally written plugins
which takes a SQL statement as an argument, this plugin failed
because of of the size of the field STRING_VALUE in the
Core.AlgorithmParam table:

   SQL> describe Core.AlgorithmParam;
    Name                                      Null?    Type
    ----------------------------------------- -------- ----------------------------
    ALGORITHM_PARAM_ID                        NOT NULL NUMBER(10)
    ALGORITHM_PARAM_KEY_ID                    NOT NULL NUMBER(5)
    STRING_VALUE                                       VARCHAR2(1000)
   [...]

The SQL statement I tried to run through the plugin exceeded
1000 characters.  I would think that SQL arguments would be
common for GUS plugins, and we use such plugins often at the
Preuss Lab.  A solution to this immediate problem would be to
increase the STRING_VALUE column to VARCHAR2(2000), though
eventually I or someone else may exceed this limit as well.

Just letting people know problems we are running into.

Thanks, Josef


Josef Jurek, Ph.D.

Daphne Preuss Laboratory
Molecular Genetics and Cell Biology
The University of Chicago
ju...@cs...

voice: (773) 834-3985
fax:   (773) 702-6648