I'm having a problem with the size of a varchar2 being passed to/from a Oracle8 pl/sql stored procedure. After 2000 characters I get oracle errors. The parameter type = <in-out> and data type = string. The data length doesn't affect the error- making the length greater than 2000 has no effect. Where is the size limit set? In Netdynamics or in Oracle? Shouldn't Oracle8 have a size limit of 4000 character? The size limit on varchar2 values stored in tables is smaller than varchar2 variables within a stored procedure. What size limit is being imposed on the varchar2 passing to/from the stored procedure? Should the data type be long instead of string? This size limit is compounded a the problem with passing multiple values back from one stored procedure. thanks for help, chuck illingworth TDS-CS [EMAIL PROTECTED] _________________________________________________________________________ For help in using, subscribing, and unsubscribing to the discussion forums, please go to: http://www.netdynamics.com/support/visitdevfor.html For dire need help, email: [EMAIL PROTECTED]
