Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » list of value, static (run time error out of memory at line 38 )
list of value, static [message #583885] Mon, 06 May 2013 08:28 Go to next message
ariffcal
Messages: 107
Registered: April 2011
Senior Member
Below are the settings of list of value.

103 cargo_database
Page: 2 Cargo
Name
Display As - Select a Display - Checkbox Color Picker Date Picker Date Picker (Classic) Display Image Display Only File Browse... Hidden List Manager Number Field Password Popup LOV Radio Group Rich Text Editor Select List Shuttle Stop and Start HTML Layout Table Text Field Text Field with Calculator Popup Text Field with autocomplete Textarea
[Text][Textarea][Select List][Radio Group][Popup LOV][Checkbox][Date Picker][Hidden][Display Only]

Displayed Sequence
Region - Select a Region - Breadcrumbs (1) 1 Edit CARGO (1) 10
Begin On New Line No Yes FieldNo Yes ColSpan Row Span
Width Maximum Width
Height
Label Label
Horizontal / Vertical Alignment Above Below Center Center bottom Center center Center top Left Left bottom Left center Left top Right Right bottom Right center Right top
Template - Select a Template - No Label Optional Optional with help Required Required with help
HTML Table Cell Attributes

Settings Value Required Yes No
Format Mask

Format Mask








Page Action when Value Changed None (Default)Submit PageRedirect and Set ValueRedirect to Page (based on selected value)Redirect to URL (based on selected value)
Allow Multi Selection YesNo
Execute Validations YesNo
Lists of Values Named LOV - Select Named LOV - Report Row Per Page
Display Extra Values No Yes
Display Null Value No Yes
Null Display Value Null Return Value
Cascading LOV Parent Item(s)

Page Items to Submit

Optimize Refresh Yes No
List of values definition
STATIC:EACH,PACKET,ROLL,BOX,MTR,PAIR
Create or edit static List of Values


However at run time it is giving out of memory at line 38


Pls help
Re: list of value, static [message #583890 is a reply to message #583885] Mon, 06 May 2013 09:40 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm not sure I understand what you meant to say by copy/pasting the whole Apex page over here (a screenshot would be much better, in my opinion). That is unreadable.

As a topic title suggests "list of values", nothing really wrong about it - the way it is created now, it works OK (as far as I could test it). Also, I'm not sure it is capable of causing out of memory error. Maybe if you selected zillion of records ...

Did you run that page in debug mode? What useful information did it reveal (if any)?
Re: list of value, static [message #584042 is a reply to message #583890] Wed, 08 May 2013 03:51 Go to previous messageGo to next message
ariffcal
Messages: 107
Registered: April 2011
Senior Member
There is nothing in the debug mode .

I am not sure if I am setting the debug mode properly .

It shows elasped time , and all that .

Not showing the value of the UNIT
Re: list of value, static [message #584053 is a reply to message #584042] Wed, 08 May 2013 05:13 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It means that you can run the page, right? When do you encounter the error? As of debug mode: when you run the page, at the bottom of the screen you'll see number of buttons; one of them is "Debug". Push it. You're in debug mode now. Once you're done, push the "View debug" button. It'll open a new window with some links - follow the most recent one.

What is your working environment (database, Apex, operating system)? Specify their version number, please.
Re: list of value, static [message #584054 is a reply to message #584053] Wed, 08 May 2013 05:47 Go to previous messageGo to next message
ariffcal
Messages: 107
Registered: April 2011
Senior Member
I can run the page . I encounter the error , when I select , other than the , first item . I have only 8 items in the list of values . I am working in windows xp , apex .
Re: list of value, static [message #584060 is a reply to message #584054] Wed, 08 May 2013 06:34 Go to previous messageGo to next message
ariffcal
Messages: 107
Registered: April 2011
Senior Member
In debug mode ,

I am getting the below messages ( I am sorry , I understand that reding is difficult )


.03100 0.01600 l_select_list= "FEDID", "SHIPPING_BILL_NO", "MATERIAL_DETAILS", "F_ROM", "RECEIVE_DATE", "TOO", "SEND_DATE", "FEDEX_NO", "U_NIT", "QTY", "R_EMARK", "TMP_STMP", 4
1.04700 0.01500 using existing report settings (different id) 4
1.06200 0.01600 select null as apxws_row_pk, "FEDID", "SHIPPING_BILL_NO", "MATERIAL_DETAILS", "F_ROM", "RECEIVE_DATE", "TOO", "SEND_DATE", "FEDEX_NO", "U_NIT", "QTY", "R_EMARK", "TMP_STMP", count(*) over () as apxws_row_cnt from ( select * from ( select "FEDID", "SHIPPING_BILL_NO", "MATERIAL_DETAILS", "F_ROM", "RECEIVE_DATE", "TOO", "SEND_DATE", "FEDEX_NO", "U_NIT", "QTY", "R_EMARK", "TMP_STMP" from "CARGO" ) r ) r where rownum <= to_number(:APXWS_MAX_ROW_CNT) 7
1.07800 0.15600 IR binding: ":APXWS_MAX_ROW_CNT"="APXWS_MAX_ROW_CNT" value="10000" 4
1.23400 0.01600 Printing rows. Row window: 1-15. Rows found: 8 4
1.25000 0.00000 Computation point: Before Footer 4
1.25000 0.00000 Computation point: After Box Body 4
1.25000 0.01500 Processing point: After Box Body 4
1.26500 0.00000 Processing point: Before Footer 4
1.26500 0.01600 Show page tempate footer 4
1.28100 0.01600 Computation point: After Footer 4
1.29700 0.00000 Processing point: After Footer 4
1.29700 0.03100 Log Activity: 4
1.32800 0.00000 End Show Page 4
1.32800 - v$sesstat.statistic# = 436: execute count=2 4 -


1 - 52



Re: list of value, static [message #584071 is a reply to message #584060] Wed, 08 May 2013 09:13 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I might be wrong, but this looks OK to me. No error at all. Is this the whole debug page?

Also, it looks like an interactive report page. Does it retrieve any data? Is it related to your first message (which mentions a list of values)? If so, how?

Did you try to rewrite the whole page? Not "fix" existing one - delete it and create a brand new page?
Previous Topic: Hyperline on email to run on demand process
Next Topic: Apex
Goto Forum:
  


Current Time: Thu Mar 28 13:05:44 CDT 2024