Hola, tengo un problema con el tamaño de los argumentos de un procedimiento almacenado, en un servidor sybase 12.5 reclama que el tamaño maximo permitido para un argumento de tipo char es de 255 en cambio en otro servidor sybase 12.5 el procedimiento funciona perfectamente.

halguien sabe de alguna configuracion que afecte el tamaño de los parametros de un procedimiento almacenado??

saudos
Like it on Facebook, +1 on Google, Tweet it or share this topic on other bookmarking websites.
  • Re: Tamaño argumentos en procedimiento almacenado

    by » 10 years ago


    Tu problema se presenta cuando metes los valores al procedure, o cuando el procedure trata de insertar o modificar algo en alguna de tus tablas, de ser así las tablas son iguales, el tamaño de páginas usado en cada server es igual?

    Saludos

  • Re: Tamaño argumentos en procedimiento almacenado

    by » 10 years ago


    al hacer el llamado del SP esta truncando.

    muchas gracias

  • Re: Tamaño argumentos en procedimiento almacenado

    by » 10 years ago


    Y el tamaño de tus páginas de datos es igual en los servidores?

  • Re: Tamaño argumentos en procedimiento almacenado

    by » 10 years ago


    se agrego un nuevo antcedente, y es que de algunos clientes funcionael sp y de otros no, el sp recibe un varchar de 1000 y lo intenta insertar en la BD, de distintos ambientes pero misma bd en algunos inserta en otros no :s


    esta es la configuracion de ambos servidores:




    /***************************************************************************/
    /***************************************************************************/
    /***************************************************************************/
    /***************************************************************************/
    SERVIDOR 1
    /***************************************************************************/
    /***************************************************************************/
    /***************************************************************************/
    /***************************************************************************/
    /***************************************************************************/

    Limits independent of page size:
    ================================


    Server-wide, Database-specific limits and sizes

    Max engines per server : 128
    Max number of logins per server :
    2147516416
    Max number of users per database :
    2146484223
    Max number of groups per database : 1032193
    Max number of user-defined roles per server : 1024
    Max number of user-defined roles per (user) session : 127
    Min database page size : 2048
    Max database page size : 16384
    Initial master database logical page count : 3072
    Initial model database logical page count : 1024
    Default logical pages in a new database : 1024
    Min size of sybsystemprocs, in MB : 100
    Recommended size of sybsystemprocs, in MB : 105
    Max length of a database-object name : 30

    Database page-specific limits

    APL page header size : 32
    DOL page header size : 44

    Table, Index related limits

    Max number of columns in a table/view : 1024
    Max number of indexes on a table : 250
    Max number of user-keys in a single index : 31
    Max number of referential constraints per table : 192
    Max number of keys in a referential integrity constraint : 16

    Cache manager related limits

    Default number of buffers in a named cache : 256

    General SQL related

    Max size of character literals, sproc parameters : 16384
    Max size of local @variables in T-SQL : 16384
    Max number of arguments to stored procedures : 2048
    Max number of aggregates in a COMPUTE clause : 254
    Max number of arguments to Java methods : 31
    Max number of user tables in a single SQL statement : 50
    Max number of internal work tables in a single SQL statement : 14
    Max number of subqueries in a single statement : 50
    Max number of user-supplied expressions in select list : 4096
    Max number of AND/OR conditions in WHERE clause : 1024

    Limits as a function of the page size:
    ======================================

    Item dependent on page size : 2048
    4096 8192 16384
    -----------------------------------------------------------------------------------------------------------

    Server-wide, Database-specific limits and sizes

    Min number of virtual pages in master device : 6660
    12292 24580 49156
    Default number of virtual pages in master device : 13316
    24580 49156 98308
    Min number of logical pages in master device : 6656
    6144 6144 6144
    Min number of logical pages in tempdb : 1536
    1024 1024 1024

    Table-specific row-size limits

    Max possible size of a log-record row on APL log page : 2014
    4062 8158 16350

    Physical Max size of an APL data row, incl row-overheads : 1962
    4010 8106 16298
    Physical Max size of a DOL data row, incl row-overheads : 1964
    4012 8108 16300

    Max user-visible size of an APL data row : 1960
    4008 8104 16296
    Max user-visible size of a DOL data row : 1958
    4006 8102 16294
    Max user-visible size of a fixed-length column in an APL table : 1960
    4008 8104 16296
    Max user-visible size of a fixed-length column in a DOL table : 1958
    4006 8102 16294
    Max user-visible size of a variable-length column in an APL table : 1948
    3988 8068 16228
    Max user-visible size of a variable-length column in a DOL table : 1954
    4002 8098 16290

    Max number of rows per APL data page : 256
    256 256 256
    Max number of rows per DOL data page : 166
    337 678 1361

    Index-specific row-size limits

    Max index row-size, including row-overheads : 650
    1300 2700 5400
    Max user-visible index row-size : 600
    1250 2600 5300

    OAM-manager related limits

    Max number of OAM entries per OAM page : 250
    506 1018 2042

    Text-manager related limits

    Max text size available for user data : 1800
    3600 7650 16200

    Cache manager related limits

    Min size of named cache (KB) : 512
    1024 2048 4096
    Default size of named cache (KB) : 1024
    2048 4096 8192

    DBCC execution completed. If DBCC printed error messages, contact a user
    with System Administrator (SA) role.



    /***************************************************************************/
    /***************************************************************************/
    /***************************************************************************/
    /***************************************************************************/
    SERVIDOR 2
    /***************************************************************************/
    /***************************************************************************/
    /***************************************************************************/
    /***************************************************************************/
    /***************************************************************************/




    Limits independent of page size:
    ================================


    Server-wide, Database-specific limits and sizes

    Max engines per server : 128
    Max number of logins per server :
    2147516416
    Max number of users per database :
    2146484223
    Max number of groups per database : 1032193
    Max number of user-defined roles per server : 1024
    Max number of user-defined roles per (user) session : 127
    Min database page size : 2048
    Max database page size : 16384
    Initial master database logical page count : 3072
    Initial model database logical page count : 1024
    Default logical pages in a new database : 1024
    Min size of sybsystemprocs, in MB : 100
    Recommended size of sybsystemprocs, in MB : 105
    Max length of a database-object name : 30

    Database page-specific limits

    APL page header size : 32
    DOL page header size : 44

    Table, Index related limits

    Max number of columns in a table/view : 1024
    Max number of indexes on a table : 250
    Max number of user-keys in a single index : 31
    Max number of referential constraints per table : 192
    Max number of keys in a referential integrity constraint : 16

    Cache manager related limits

    Default number of buffers in a named cache : 256

    General SQL related

    Max size of character literals, sproc parameters : 16384
    Max size of local @variables in T-SQL : 16384
    Max number of arguments to stored procedures : 2048
    Max number of aggregates in a COMPUTE clause : 254
    Max number of arguments to Java methods : 31
    Max number of user tables in a single SQL statement : 50
    Max number of internal work tables in a single SQL statement : 14
    Max number of subqueries in a single statement : 50
    Max number of user-supplied expressions in select list : 4096
    Max number of AND/OR conditions in WHERE clause : 1024

    Limits as a function of the page size:
    ======================================

    Item dependent on page size : 2048
    4096 8192 16384
    -----------------------------------------------------------------------------------------------------------

    Server-wide, Database-specific limits and sizes

    Min number of virtual pages in master device : 6660
    12292 24580 49156
    Default number of virtual pages in master device : 13316
    24580 49156 98308
    Min number of logical pages in master device : 6656
    6144 6144 6144
    Min number of logical pages in tempdb : 1536
    1024 1024 1024

    Table-specific row-size limits

    Max possible size of a log-record row on APL log page : 2014
    4062 8158 16350

    Physical Max size of an APL data row, incl row-overheads : 1962
    4010 8106 16298
    Physical Max size of a DOL data row, incl row-overheads : 1964
    4012 8108 16300

    Max user-visible size of an APL data row : 1960
    4008 8104 16296
    Max user-visible size of a DOL data row : 1958
    4006 8102 16294
    Max user-visible size of a fixed-length column in an APL table : 1960
    4008 8104 16296
    Max user-visible size of a fixed-length column in a DOL table : 1958
    4006 8102 16294
    Max user-visible size of a variable-length column in an APL table : 1948
    3988 8068 16228
    Max user-visible size of a variable-length column in a DOL table : 1954
    4002 8098 16290

    Max number of rows per APL data page : 256
    256 256 256
    Max number of rows per DOL data page : 166
    337 678 1361

    Index-specific row-size limits

    Max index row-size, including row-overheads : 650
    1300 2700 5400
    Max user-visible index row-size : 600
    1250 2600 5300

    OAM-manager related limits

    Max number of OAM entries per OAM page : 250
    506 1018 2042

    Text-manager related limits

    Max text size available for user data : 1800
    3600 7650 16200

    Cache manager related limits

    Min size of named cache (KB) : 512
    1024 2048 4096
    Default size of named cache (KB) : 1024
    2048 4096 8192

  • Re: Tamaño argumentos en procedimiento almacenado

    by » 10 years ago


    Me suena a que es algo en el cliente, exactamente cual es tu error que sale.

You do not have permissions to reply to this topic.
Powered by CjForum