Oracle Database Error: Value length exceeds the parameter size

Toad Data Point & Toad Intelligence Central
1

Hi,
Please help me to identify what is required to change in Toad Data Point version 3.2.0 to successfully run the attached store procedure.
When running the procedure in TDA 3.2, I get this messaage, “Oracle Database Error: Value length exceeds the parameter size”; this error applies to the value given in p_site_location; if this exceeds 38 characters then the error is generated. Please note the field in the oracle table can take upto 50 characters.
On the other hand, if I execute the same store procedure from an old version of TOAD, I do not get any error and the script gets successfully executed as it should be.
Thanks in advance for your quick support on this problem.

UPDATE_BFOFIELDS_JOB_FS101.txt (3.73 KB)

2

Monica,

Could you provide the screenshots of how the 2 versions of TDA behavior differently?

Thanks!

3

As requested, I am attaching the screen shots.
Screen Shots.docx (256 KB)

4

Thanks Monica,

Is that possible to give us the tables DDL used in the procedure to reproduce the issue?
Thanks!