|
Home > Archive > SQL Anywhere Feedback > August 2005 > Re: Use CLOB for some syncora.sql parameters
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: Use CLOB for some syncora.sql parameters
|
|
| Breck Carter [TeamSybase] 2005-08-08, 1:23 pm |
| Still wishin' and hopin' for this one... :)
Breck At 9.0.2.3124
On 14 Sep 2004 13:35:18 -0700, "Breck Carter [TeamSybase]"
< NOSPAM__bcarter@risi
ngroad.com> wrote:
>Use CLOB instead of VARCHAR for the parameters passed to the various
>ml_add_* procedures in the Oracle file syncora.sql, where the
>underlying column in the associated ml_* table is declared as CLOB
>instead of VARCHAR.
>
>This will make it easier to call these procedures from SQL code. For
>example, to copy all the scripts from one version to another, it is
>currently necessary(?) to call the DBMS_LOB.SUBSTR function to convert
>ml_script.script from CLOB to VARCHAR in order pass the value to
> ml_add_lang_table_sc
ript and ml_add_lang_connecti
on_script.
>
>This affects several procedures involving scripts and properties.
>
>Breck
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
| Graham Hurst 2005-08-26, 3:23 am |
| I'm told it has already been done for version 10, so someone must have
been listening!
Cheers,
Graham
Breck Carter [TeamSybase] wrote:
> Still wishin' and hopin' for this one... :)
>
> Breck At 9.0.2.3124
>
> On 14 Sep 2004 13:35:18 -0700, "Breck Carter [TeamSybase]"
> < NOSPAM__bcarter@risi
ngroad.com> wrote:
>
>
>
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
|
|
|
|
|