Re: Problems with SQLFORMS 3.0

Hi Julio.

I had the same problem with Forms 4.5.
I found out that the stored procedure returns values with a lenght up to 40 digits and forms can only accept number values with a length of 38 digits.

Try to trunc your out-parameter to maximum 38 digits. For testing you could use this: TRUNC(OUT_VARIABLE) to decrease the size of the out-number. Later you should use TRUNC(OUT_VARIABLE,<your_precision>) where <your_precision> is the precision, that you want to have for the out-number, but always having in mind not to exceed the total length of 38 digits.

Hope this helps.

Angelo.  

Julio Negueruela wrote:
>
> Well, I had an On-error triger so the errors messages weren't shown to
> me. I've got the following error:
> Ora-01459 Invalid length for variable character strig.
> The manual says:
>
> The buffer length was less than the minimum required (two bytes) or
> greater than it's length at bind time minus two bytes.
> Action: None. Buffer length is set correctly by Oracle at fetch time.
>
> It sounds fine but doesn't work to me !!!
>
> The procedure has 20 parameters in an one parameter out, this one is the
> message wich is retuned to me by the procedure. Any idea?
>
Received on Thu Oct 15 1998 - 06:40:34 CDT