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
>  
>