Application Express :: Plugin For Academic Time Table?

Sep 18, 2013

need to build an application for registering the teaching hours of academic staff based on faculty's Time TableWhat is the best plugin for doing that?

For example, is this the best from your point of view - Region Plugin - SkillBuilders Calendaror the calendar region of apex can do that I need ability of adding lectures with their detail in flexible

View 0 Replies


ADVERTISEMENT

Application Express :: Google ReCaptcha Plugin In 4.2

Oct 31, 2012

We have just upgraded from APEX 4.0.1 to APEX 4.2. The installation and migration of the applications went very well (after installing the patch for the import of the workspaces :-) ). But we have met a problem - we have a Google reCaptcha plugin on 101 page (authentication page). It has runs pretty well on 4.0.1, but after upgrade whole plugin item just has disappeared from 101. Actually it has disappeared from IE9, IE8, Mozilla 16 and Google chrome. The only browser that is displaying reCaptcha is Opera.

why this happened and how we can fix it? The client wants to make some tests this week and we have to fix the situation.

View 1 Replies View Related

Application Express :: Spinbox Plugin For Tabular Form?

Sep 19, 2012

have a spinbox plugin for tabular forms? I saw a plugin on jquery but I could not download it.

APEX 4.1
Oracle 10g Rel 2 DB

View 0 Replies View Related

Application Express :: Conditional Display With Re Captcha Plugin

Aug 22, 2012

I implemented the re Captcha plugin and it works ok. What I want to do is, on the same page where the captcha is displayed, to have a report region that is displayed conditionally based on the captcha result.

More specifically, the page has two items for user input (the captcha and a text item) and a Submit button. If the captcha is successful, then the text item will be submitted and the region displayed. The problem I'm running into is that the text item is always submitted regardless of the captcha.

View 3 Replies View Related

Application Express :: Can Use Static List With Skillbuilders SuperLOV V2.0 Plugin

Oct 1, 2012

I would like to convert some existing application popup LOV items that currently use a static list for the LOV values.I have not been able to find instructions on how to use the existing popup static list (or create a new static list) with the new SuperLOV plug-in. Is this possible to do?

If an example or instructions are available, a link to these.

View 3 Replies View Related

Application Express :: Skill Builders Calendar Plugin When Using Session State Protection?

Jun 13, 2013

I have a calendar region using SkillBuilders plug-in. When click on an event, a modal page opens showing the event details and allowing the user to modify it. Recently, I enabled Session State Protection in my pages, so I changed my query in the calendar region to use the APEX_UTIL.PREPARE_URL function when generating the URL to edit the event. Now, when I click on an event, the URL looks like: [URL]....

p=34925:3:102130990572822::::P3_ID:41&cs=3DE8BFFE2FCA925B7716361D6ECFC546B If you notice the URL has & before the check-sum (cs), instead of just & and it is causing an error on my page. The reason is that the plug-in is escaping special characters. If I change the source of the plug-in to use this: 
l_url := l_column_value_list(6)(x); Instead of: 

[code]....

View 0 Replies View Related

Application Express :: Validate Date And Time

Jul 18, 2012

I am using Apex 3.2

I have a field on my form called P4_START..It has a format mask of DD.MM.YYYY HH24 MI and a default value of TO_CHAR(SYSDATE, 'DD.MM.YYYY HH24:MI').

I need to create a validation which fires on save, to ensure the user is inputting a date and time

View 5 Replies View Related

Application Express :: To Automatically Update The Value Every Time A New Row Is Inserted

Dec 3, 2012

I have a procedure I need to feed a number into in order to generate some thumbnails.

I'm trying to automatically update the value every time a new row is inserted but I'm having trouble with the code.

DECLARE

varInt NUMBER :='SELECT MAX(IMAGE_ID) FROM IMAGES';

begin
create_blob_thumbnail(varInt);
end;I get the error +'ORA-06502: PL/SQL: numeric or value error: character to number conversion error'+

If I run the query SELECT MAX(IMAGE_ID) FROM IMAGES, it returns the last row ID I created just as it should. The create_blob_thumbnail(varInt) procedure works fine if I manually put in a number.

View 3 Replies View Related

Application Express :: Current_timestamp Vs Daylight Saving Time

Jan 27, 2013

the time in my online application is 1 hour later than is actually is. So 21.30is actually 20.30. This is my code:

    select 1
    from   vex_rondes rde
    where rde.datum_einde < current_timestamp
    and    rde.id = b_rde_idrde.datum_einde

is a date column filled with dates of course ins this format: 10-01-2013 20:45 (10th January 2013 20h45).How can I get this current_timestamp correct?

select 1
    from   vex_rondes rde
    where rde.datum_einde+(1/24) < current_timestamp
    and    rde.id = b_rde_idbut that's not very elegant nor generic...

View 1 Replies View Related

Application Express :: Change Read Only Condition From Always To None On Real Time

Sep 4, 2012

Can we change the condition of an item from always to none on the real time ? How ?

View 3 Replies View Related

Application Express :: Dynamic Actions Not Updating Report Every Time

Aug 29, 2013

I have a page which downloads statspack reports from different servers and stores them in APEX. As well as this it also display a summary of data (top 5 wait events & load profile info) when hovering an icon: [URL]... The chart will refresh itself and display the data based on the value of P10_SNAPVAL (storing the PK value). The report does not do as I expect it to do (it isn't refreshing the table). I have the following:

PL/SQL Dynamic Content region making the report Dynamic Action- Event: Change- Item: P10_SNAPVAL- Action: Refresh- Affected Element: Region - Load Profile (the PL/SQL Dynamic Content)- Event scope:

I've tried both bind & live The value of P10_SNAPVAL is changed whenever the user hovers a penguin icon (this works because the chart works). 

$('img[name=summary]').mouseover(function() {
var get = new htmldb_Get(null,html_GetElement('pFlowId').value, nu

View 15 Replies View Related

Application Express :: Database Link Slows Down The Response Time

Jul 11, 2013

I have a question regarding db link. I have a query that uses a database link, i speed it up by adding the DRIVING_SITE hint and it worked when executed from

sql*plus or pl/sql developer.

It returns results in 3 seconds or even less. However, when i put this query back into the APEX application, specifically into an interactive report page -- it runs for 3 mins!

View 1 Replies View Related

Application Express :: File Upload Abort After Long Time

Aug 2, 2012

I am trying to upload big files to individual table with BLOB column. During upload process after long time approx. 2h I get the following error message:

[#|2012-08-01T19:03:01.667+0200|WARNING|sun-appserver2.1|java.lang.Class|_ThreadID=27;_ThreadName=httpSSLWorkerThread-8082-2;_Reques
tID=4cec5fc8-b9e1-4017-a859-8759ec1f5d37;|oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(OracleBlobOutputStream.java:236)
java.io.IOException: ORA-01013: user requested cancel of current operation
[code]....

I am using Glassfish Server v2.1.1 with APEX Listener v1.1.3.243.11.40...The Timeout parameters for JDBC settings in APEX Listener are default. Thus I would expect to abort earlier to be an issue of JDBC Connection?

View 1 Replies View Related

Application Express :: Response Time Too Long - 4.2 RESTful WebService

Aug 26, 2013

i need to consume web services within my apex Apps, i tried sample app from here: URL....it worked, but response time is about 15 seconds, then i tried another with Google Geocode APIURL.... and again time is 15-16 seconds. It's normal response time from Apex Web Services or is there something to do.

View 0 Replies View Related

Application Express :: Default Time In Data Picker Calendar

Aug 3, 2012

I'm using one of the new Date/Time picker items in Apex 4.0.2. When the user clicks the Calendar image the Calendar is displayed with the current date and time. However I would like it to display by default the current date and a time of 1000hrs.

View 1 Replies View Related

Application Express :: Assigning Value To Select List Only First Time Page Loads

Jan 3, 2013

I am trying to set the intial value of "Select List" to APP_USER the only first time when the page loads and use it to filter the report, any other time once the page is loaded the user should select another value from the Select List then click the submit button to display the details in the report, i tried to achieve this by setting "select List" creating LOV for Select List then set default=APP_USER but now the problem any time you click the submit button it reset the "Select List" from selected value back to default so how can you achieve this to set the value of Select List only the first time the page loads?

View 1 Replies View Related

Application Express :: Login First Time Asked About Server XDB Username And Password

Aug 27, 2012

when i try to login to apex for first time (10.10.0.170:5555) it asked about server XDB username and password,i dont know which username and password i can use

View 4 Replies View Related

Application Express :: Page Input Item Label Conditional Style At Run Time

Feb 6, 2013

We have an issue after migrating to apex 4.2.1. We have a select list and use another couple of dummy items to be used as its label instead of giving the text value to the LABEL control. Only one of the dummy items is shown as a label for the select list conditionally based on another value. It was working fine with the earlier versions upto 4.1, but with the introduction of grid in 4.2, its now displaying the select list on a new row (ie the lable in one row and the select list on the next row).

However, we really would like to solve this by having a way to display the label of the select list either in "required format style" or as an "optional style". The display style should be determined only at runtime.

Example. Say P100_MY_SELECT_LIST is the select list

The label for this item is "My Select List Label"

I have another dummy item P100_DUMMY

if P100_dummy = 1 then the label "My Select List Label" should be displayed in red and with an * *My Select List LabelOtherwise it should be in black and without * My Select List Label.

View 3 Replies View Related

Get One Row For A Student (academic Program) - Effective Dated Error?

Jun 6, 2013

I have a query where I'm trying to get one row for a student that is their academic program. A view PS_NTSR_PRGPLN_VW returns all active programs. This student has three.The query is pretty straightforward but I'm not getting any rows, and I think it is because I'n not using MAX(pe.effdt) correctly.

select * from PS_NTSR_PRGPLN_VW h
where h.emplid = 'xxxxxx'
AND h.institution = 'ABCD'
AND h.acad_plan_type = 'MAJ'
AND h.primary_indicator = 'Y'

[code]....

I've had rows where I have the same plan_sequence so I do need to use MAX(pe.effdt), but when I do I get zero results.

View 1 Replies View Related

Application Express :: Insert Into History Table When Update Action Is Performed On Tabular Form View Or Table

Aug 24, 2013

My scenario is I need to insert into History table when a record is been updated into a tabular form(insert the updated record along with the additional columns Action_by,Action_type(Like Update or delete) and Action Date Into History table i.e History table contains all the records as the main table which is been visible in tabular form along with these additional columns ...Action_by,action_type and action_date.

So now i dont want to create a befor/after update trigger on base table rather i would like to create a generic procedure which will insert the updated record into history table taking the page alias and pade ID as the parameters(GENERIC procedure is nothing but whcih applies to all the tabular forms(Tables) contained int he application ).

View 2 Replies View Related

Application Express :: Form On A Table With Report

Apr 24, 2013

I have one question. Is possible export form to CSV (or PDF) for example? If it is, what is the process?

View 0 Replies View Related

Application Express :: Upload Data From CSV / XLS To Table

Jul 25, 2013

I am new to the Upload data from excel to Table..... how to implement on this.....I need code for UpLoad CSV/XLS Files to the Table ....Table name T_UPLOAD have contains 40 columns....

View 3 Replies View Related

Application Express :: Import Xml File Into A Table

Dec 13, 2012

I'm trying to upload a xml file into a table but I don't know which separator do I have to select to show the columns well. I does not recognize the columns.

View 5 Replies View Related

Application Express :: Pivot Table Layout?

Nov 5, 2012

in my application i have a requirement as follows

1) column 1 indicator
2) column 2 important.

and the other columns are target actual and current year, previous year and next year.the layout should be in pivot table lay out as follows here the three columns will be saved dynamically as 2012,2011,2013 and the respecitive percentage in target and actual column

current_year previous_year next_year
target 10% 12% 5%
actual 5% 8% 5%

View 1 Replies View Related

Application Express :: Unloading Data From A Table

Mar 21, 2013

I'm trying to unload data from a table, so i go to SQL Workshop > Utilities > Data Workshop > Data Unload to Text, i select my table, select the columns, give the condition to unload the data of the last month (between sysdate-28 and sysdate), then i select the comma separator, including the column names, and finally press "Unload Data"...the file is downloaded correctly, but when i open the file, the data is not ordered as i expected.

View 1 Replies View Related

Application Express :: Formatting A Table Without Headings

Apr 3, 2013

I want to make a report which is formated (rebuilding an older tool in Access).

So on the one hand I need some formattings which I implemented with the search bar in the interavtive report. (content of the first column is the heading for a table with the rest of the content of all rows which have the sam content in the first column) On the other hand I don't want to show the headings of the columns, what I solved with the classic report(report attributes/ column attributes: none).
Is the a solution to match these two requirements in one report?

View 4 Replies View Related

Forms :: Plugin Is Not Supported Error

Jul 14, 2013

I am having a problem in the process of run the Form on web browser.We learned builder Use the Oracle 10g and Oracle Developer Suite 10g

View 6 Replies View Related

Application Express :: Page Validation Against Table Definition?

Apr 29, 2013

I am trying to apply page validations on a tabular form. The form allows users to update data in a database table. I have created some validations such as "column x must not be null" etc and on submit, the error message appears and the relevant cells are highlighted in red. All ok so far.

However, for the primary key, I am relying on the table definitions in the Oracle database to not allow duplicate row entries. When a user tries to enter a duplicate row the error message appears but the relevant row / cells are not highlighted, just the row number is given. In a table with many rows this is a bit annoying.

Is there anyway to get the cells to highlight in red for such circumstances or do I need to create the primary keys within APEX itself?

APEX 4.2.1.00.08

View 0 Replies View Related

Application Express :: Automatic Update Of Collection And Table?

Oct 29, 2013

I am trying to update a collection and a table.I got some example code and installed on oracle.com, but I just can't seem to get it to work.I always get an errorORA-20001: Current version of data in database has changed since user initiated update process.I think the problem lies with comparing the checksums, but I cannot spot the mistake 

View 2 Replies View Related

Application Express :: Show Count From Another Table In A Report

May 29, 2013

I am using Apex 3.2...I have the following sql in a report

select
a.jobid jobid,
a.jobid related_jobs,
to_char(a.startdate, 'dd.mm.yyyy hh24:mi:ss') startdate,
to_char(a.enddate, 'dd.mm.yyyy hh24:mi:ss') enddate

from jobs aI would like to show a count from another table where the jobid = jobid from the above sql.The problem is I don't know how to refer to the jobid in my extra sql.Here is my extra sql for the new count column.

(select count(1)
from jobs a, loghead b, dba_scheduler_job_run_details c
where a.logid = b.logid
and b.session_id(+) = c.session_id
and a.jobid = :P3_JOBID) no_of_related_jobs.

This will not work because :P3_JOBID is a page item.I have also tried #JOBID#, but got en error, as it was not recognised.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved