Home » Developer & Programmer » Reports & Discoverer » How to get length of column data in oracle form
How to get length of column data in oracle form [message #284116] Wed, 28 November 2007 23:41 Go to next message
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
Member

Dear How i can got Length of column data on Oracle developer 6i.
..........................
I Know in SQL
Select length(XYZXYZXYZ) from ZZZ;
but it is not work in developer form level function.
Re: How to get length of column data in oracle form [message #284125 is a reply to message #284116] Wed, 28 November 2007 23:55 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Dear I have used the length function in Developer. Could you plz send me the main code where you are using it. So I can get the idea.

Regards,
Azam Khan
Re: How to get length of column data in oracle form [message #284131 is a reply to message #284116] Thu, 29 November 2007 00:07 Go to previous messageGo to next message
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
Member

Dear friend....
i use this in formula coulnm in oracle report...
Here given error is............
--no function with name 'LENGTH' exists in this scope.
but if i run the script in sqlplus/TOAD then it gives my required O/P
-------------------------query-------------------------
Select sum(a.Weight) into rolling_op_qty
from PD_PROCESS_OUTPUT_DTL a, Pd_PROCESS_INPUT_DTL b,
PD_PROCESS_HDR c, HM_SHIFT_MST d
where a.Delete_Mark=0 and b.Delete_Mark=0 and c.Delete_Mark=0
and a.Process_Id=b. Process_Id and a.Input_Coil_No=b.Input_Coil_No
and a.Process_Id=c.Process_Id and c.Shift_Code=d.Shift_Code
and Substr(a.Source_Coil,1,10) in
(Select Substr(Source_Coil,1,10) from PD_PROCESS_OUTPUT_DTL
where Delete_Mark=0 and Input_Coil_No=:LOT_NO)
and b.Process_Type in ('Trimming','Rewinding')
and a.process_type not in ('CR Withdrawn','HR Withdrawn','Needs Reprocessing','Withdrawn')
and b.SOURCE_COIL in (select source_coil from pd_process_output_dtl
where next_process in ('Trimming','Rewinding')
and process_type not in ('CR Withdrawn','HR Withdrawn','Needs Reprocessing','Withdrawn')
and LENGTH(Source_Coil)<=30)
order by b.input_coil_no, a.output_coil_no;
Re: How to get length of column data in oracle form [message #284139 is a reply to message #284131] Thu, 29 November 2007 00:20 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
There are too many breakets are used. Plz check if you by mistake use invalid number of breakets.
Re: How to get length of column data in oracle form [message #284187 is a reply to message #284131] Thu, 29 November 2007 02:16 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Ziauldba, read the OraFAQ Forum Guide and finally learn how to format your post. Statement you've posted is unreadable and unacceptable; do you think someone will spend half an hour just to SEE what you've written?

If you expect the answer, help us to help you.

By the way, don't put Reports-related questions in the Forms forum.
Previous Topic: Report output to mail
Next Topic: report
Goto Forum:
  


Current Time: Fri Dec 09 13:42:08 CST 2016

Total time taken to generate the page: 0.09860 seconds