The Oracle database server allows you to create stored procedures specifying only the datatype of each parameter. Parameter length specification is optional.
To support its logging process, Sybase Replication Agent requires a length specification for all stored procedure parameters. Replication Agent accommodates procedure parameters that do not have a length specified by using a “hard-coded” length, based on the datatype specified for the parameter. If this “default” parameter length is not sufficient for your stored procedure replication needs, you can alter the Oracle procedure definition to include a length specification for the parameter.
