gusdev-gusdev

[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

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

[Steve F. <sfi...@pc...>]

ok.

there is probably a limit to how big a string can be passed through the 
unix shell command processor.

often the sql passed in is not arbitrary but conforms to an sql 
template.   in that case, the template can be hard coded into the plugin 
and parameters for it passed into the plugin.

or, the sql can be put in a file

steve

Josef Jurek wrote:

>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
>
>
>
>
>
>-------------------------------------------------------
>SF email is sponsored by - The IT Product Guide
>Read honest & candid reviews on hundreds of IT Products from real users.
>Discover which products truly live up to the hype. Start reading now.
>http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
>_______________________________________________
>Gusdev-gusdev mailing list
>Gus...@li...
>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>  
>