OraFAQ Forum: Forms » Length of the field data

Home » Developer & Programmer » Forms » Length of the field data

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Length of the field data [message #86700]

Wed, 20 October 2004 07:25

AB
Messages: 41
Registered: July 2002

Member

Hi,

�In When-Record-Instance, i'm trying to some iterations based on the length of the data of the field. A field's data is 344. I have declare a variable�ln_Length type NUMBER(8) and assigning the length of the data field value to it

�ln_Length := LENGTH(:SYSTEM.CURSOR_VALUE);

But ln_Length is showing 255 though the actual data length of field is 344. Because of this my calculations are going wrong.� The problem what I found out was, that the SYSTEM variables can hold chars of length max 255�only.

So Can you pls let me know whats the alterante solution for this. I want to use it in When-New_Record-Instance trigger itself?

Thanks and Regards

AB

Report message to a moderator

Re: Length of the field data [message #86702 is a reply to message #86700]

Wed, 20 October 2004 22:16

Himanshu
Messages: 457
Registered: December 2001

Senior Member

Hi,
Try this code:

Declare
L_val Varchar2(1000):=NAME_IN(:system.cursor_item);
Begin
message(L_VAL);
message(length(L_VAL));
End;

HTH
Regards
Himanshu

Report message to a moderator

Re: Length of the field data [message #86703 is a reply to message #86702]

Wed, 20 October 2004 22:27

AB
Messages: 41
Registered: July 2002

Member

Himanshu,
Thanks. it works. Thanks a lot

Regards
AB

Report message to a moderator

Previous Topic:	PLease clarify my doubt it's urgent
Next Topic:	How to view image in Oracle Application Server 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 09 17:34:44 CDT 2024