Project and Portfolio Management Practitioners Forum
cancel

Changing character limitation on web address validation

SOLVED
Go to solution
Highlighted
lynguyenalg
Regular Contributor.

Changing character limitation on web address validation

Is there a way to change the charater length for the web address validation? i have a field where i used the web address validation (with the component type = web address (URL)).

I have a user who has an extremely long URL and when they go to save the request, the receive the error:

ORA-01401: inserted value too large for column {KCRT_REQUEST_DETAILS_TH-300}

Is there a way to change the length for the 'web address (url)' component type?

Thanks!
Ly Nguyen
4 REPLIES
Erik Cole
Acclaimed Contributor.
Solution

Re: Changing character limitation on web address validation

You might check and see what parameter this field is getting stored to and move it to one of 41 - 50 since those are varchar2(4000) in the database, and that's where the error is coming from...
lynguyenalg
Regular Contributor.

Re: Changing character limitation on web address validation

Thanks Erik!

Is there a way i can change the length field without changing the parameter value? Since this is in production, we have data that's already saved to the original parameter value. I guess i can run a script to copy the values in the original parameter to the new parameter. But, just wanted to see if there was another way w/o having to to update the storage.

Thanks again!
Ly
Erik Cole
Acclaimed Contributor.

Re: Changing character limitation on web address validation

Sorry, no. You'll have to update the parameter value in the workbench, then run the script to 'move' the current data to the new parameter.
lynguyenalg
Regular Contributor.

Re: Changing character limitation on web address validation

Thanks! I appreciate your help