Application Express :: No Data Found When Running Form Based On Table?

May 10, 2013

I thought this was the easy bit in APEX when you just create a form based on a table, with some validations etc. and use it to insert,update data. However on inserting the first record, I get the following error:

is_internal_error: false
ora_sqlcode: 100
ora_sqlerrm: ORA-01403: no data found

[Code]....

The form is based on a table with a primary key and the primary key is populated from an APEX-generated sequence.

I tried recreating the form, but still no good and now I get the no data error even when clicking "RUN" at page level, so the page does not even display.

View 1 Replies


ADVERTISEMENT

Application Express :: Creating Form Based On Table After Patching Apex

Aug 16, 2013

We use Apex 4.2 with Apex Listener. Recently we patched apex to 4.2.2 and now when we try to create a form based on a table, after selecting the schema and table we get the following error: "You do not have access to the schema that you are importing.

Import failed" I've seen some posts regarding this error but nothing that works with my current situation. The database grants are in place.

View 1 Replies View Related

Application Express :: Display Not-found.png For Image Type When Data Not Found?

May 22, 2013

I have an Image Type on a forum page. I want a default "not-found" image to display if the BLOB column value is null or if there is no data for that search value. The image is stored with the app: #APP_IMAGES#not-found.png

APEX 4.2 (with listener) on Oracle 11gR2

View 10 Replies View Related

Application Express :: No Data Found Error When Trying To Import CSV File To Table?

Oct 16, 2012

Not able to understand what's wrong with the code. I am trying to import data to a table using a CSV file. I have exported the data (CSV) from the interactive report and I am just trying to insert the same data to the table, through a process. When, I tried to do so; its throwing an error message saying NO_DATA_FOUND and file is not getting inserted into wwv_flow_files table.

But when I removed the data from the CSV file for the comments field and then tried importing the file, the process worked. I don't understand whats the problem with the code.

I have a sample app setup in my workspace for this weird problem.

[URL]

Workspace details:

CSV file with comments field and data in it - when trying to import - throws an error message NO_DATA_FOUND

CSV file with comments field and without data in it - tried importing - this worked

View 2 Replies View Related

Application Express :: Tabular Form (select List Query Based LOV)

Jul 10, 2012

I have this situation:

a tabular form with two "select list (query based LOV)" fields. The first one must affect elements in the second one. And so the second query based LOV field should has a "where attr1 = first_list_selected_value" in the query.

View 3 Replies View Related

Application Express :: ORA-01403 / No Data Found

Nov 26, 2012

if I click button RUN here -> f?p=4000:1500 i have error: ORA-01403: no data found

Problem is if I set Application - BuilderApplication xxx - User Interfaces - User Interface Details - Home URL = f?p=&APP_ALIAS.:2:&SESSION. (&APP_ALIAS searched alias for apex builder).

View 0 Replies View Related

Application Express :: Auto Populate Phone Number Based On Select List In Tabular Form

Dec 27, 2012

Ive a requirement which ive overlooked for a while now as below,

On my tabular form i have fields: Empid as Select List and when the value is picked from this Select List EmpID i want the associated/corresponding phone# displayed in its TEXT FIELD in that same row,

apex 4.1.1/Oracle 11gR2,

also i tried the below as a workaround but it doesnt fulfill my requirement, [URL]....

View 1 Replies View Related

Application Express :: No Data Found After New 4.2 Install On Weblogic With Listener

Nov 29, 2012

We just did an upgrade to 4.2 on a new WebLogic server. We are using the latest Apex Listener as well.The install seemed to go well (no errors during the DBA install) and we configured the Listener to connect to the database using the basic connection settings.I was able to login to the Admin console and create my workspace and users, but I cannot even get the workspace login screen to appear.All we get it is:

Error     Error processing request.
ORA-01403: no data found

This is the only thing that shows up when going to the default Apex URL....

View 6 Replies View Related

Application Express :: No Data Found When Adding Column Link To Classic Report

Jul 16, 2012

Oracle 11g r2, APEX 4.1.1.00.23.

I have some classic reports.

I go to Report Attributes, then I click Add Column Link in the "Tasks" right menu, it adds me a column link, I just add some text for the link and a page to go to. Then I run the report and I get :

report error: ORA-01403: no data foundTested with several classic reports on multiple pages.

Debug mode shows me :

0.43816     0.00240     ...Execute Statement: select distinct [...] order by 3,11 ,4
0.44056     0.00162     print column headings
0.44218     0.04816     rows loop: 25 row(s)
0.49037     0.00141     report error: ORA-01403: aucune donnée trouvée
0.49175     0.00078     Computation point: After Box BodyWhen I run the query in my favorite tool, I get expected results.

Did I missed something ?

View 9 Replies View Related

Application Express :: Creating A Report Not Based On A Table?

Jun 10, 2013

In APEX I've always created form on report so as to have the list of records of a table and the possibility of inserting/updating every sinle record by means of the form on it, ok?I have an application concerning classic costumers, orders, ... with a table for every item.

The problem is that I have to gather all information ao as to produce a classic bill with a typical layout where you have on your left some descriptions and on your right an amount but of course the layout is not based on a classic table, do you mean?Do I have to create a table in which I'll add data and null values so as to get the layout desired

View 2 Replies View Related

Application Express :: Copying Form Data To Clipboard

Feb 5, 2013

I have made one form and trying to pick up the data available on the form by pressing a copy button and want to take all the date into clip board. for an example I'm just picking one field at the moment named as p213_que_item_ref

following code is defined as application_process getquerydet (process point ondemand)

declare
item_ref varchar(30);
begin
item_ref = :p213_que_item_ref
HTP.prn (item_ref)
End;

In the header of the form querydetailsregion following code has been added

<script language="JavaScript" type="text/javascript">
function f_copytoCB ()
{
var get = new htmldb_Get(null,&APP_ID.,'APPLICATION_PROCESS=getqueryDet',0);
//var get = $v('P213_QUE_ITEM_REF')
get.add($v('P213_QUE_ITEM_REF'))
gReturn = get.get();
copy gReturn;
}
</script>

AND in the button URL added the following code

javascript:f_copytoCB();

But it is still not working .......

what is wrong with it.

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 :: 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 :: How To Create Radio Groups Dynamically Based On Records In A Table

Nov 29, 2012

below requirement..

We have certain records like SQL, PL/SQL, Reports, Forms, OAF etc in a table. We wanted to capture rating for each of these criteria. So we want a form to be displayed dynamically..

SQL 1 2 3 4 (1,2,3,4 represent radio buttons)
PL/SQL 1 2 3 4
Reports 1 2 3 4
Forms 1 2 3 4
OAF 1 2 3 4

If we add another row, XMLP in that table additional radio button should be displayed automatically..

View 4 Replies View Related

Application Express :: Compare Entries Of Tabular Form Column Against Lookup Table Or Item

Mar 28, 2013

I use APEX 4.2.0. In Tabular form, I have column of Select list type. This list has too many values and the end user must choose all these values along the tabular form rows. In other words, If the LOV consists of X, Y , Z, The End user should add three rows and choose a unique value for each row.

The problem is : This LOV is supposed to have too many values. What comes to mind is:

1- Whenever the end user picks a value, this value should disappear from the LOV of the second row ? But I have no clue how to do it?
OR
2- Whenever the end use picks a value, I should notify him/her about the remaining values that he should pick . But I have no clue how to do it ?

At the end the purpose is to make the user aware that he still has some rows to add ( values to choose ... )

I simplified the issue in simple example here:

[URL]......

workspace: somefeto
user: test
pwd: test

View 0 Replies View Related

Application Express :: How To Make Form With Report And Insert Form In Same Page

Dec 14, 2012

how to make a form with report and an insert form in the same page, these two forms are related to the same table. Our customer wants a user can add new row to the table in a form and see all of rows created by this user in a report, this report should provide edit link as well. the problem is: whenever I inserted a new row or edit a row or delete a row, and submitted, and return to this page, all of hidden items lost their values, so report is blank, and some display only items also lost their values.

View 6 Replies View Related

Application Express :: URL On Server 404 Not Found

Oct 27, 2012

after my first Apex installation I have got the above mentioned error. I have tried the following Apex calls:

localhost:7778/apex
localhost:7778/apex/apex_admin

Instead of using localhost I used the hostname or the IP address of the box without success.The whole installation process went fine from scratch. No errors, no warnings, nothing.I am using the following environment:

CentOS 6.3
Oracle 11.2.0.3 EE
Apex 4.1.1

With exec dbms_xdb.sethttpport(7778); I enabled the above port number. If I look at the output of the lsnrctl status I see that my local listener is also listening on 7778. I have no errors in the alert.log and no other trace files where I can have a look at.

View 1 Replies View Related

Application Express :: Page To Submit Not Found

Nov 29, 2012

I am using Oracle Application Express 11g

I don't have a option for "Page item to submit" in Chart Region

View 5 Replies View Related

Application Express :: Requested URL Not Found On Server

Aug 6, 2012

How could i redirect to an url in apex? I tried with adding google.com in target url but it shows

Not found

The requested URL /apex/[URL]....was not found on this server

how to assign it?

View 4 Replies View Related

Application Express :: Country NOT Found In Anycharts Maps With 4.2

Nov 7, 2012

how hard it or even if it is possible to add countries to the list of available for display in the maps build-able by APEX 4.2? We have a set of data to display by country and found that Serbia is NOT in the set of associated mapable countries..Should I try asking Anychart too? Thought Hilary would pickup on this since It involves charting in APEX...

Running on Apex 4.2, Oracle 10.2, Solaris with http server.

View 19 Replies View Related

Application Express Listener :: Restful Webservice 404 Not Found

Apr 18, 2013

i am running the following configuration:

Oracle Database 11.2.0.3
Application Express 4.2.1
apex_listener.2.0.1.64.14.25 on Glassfish 3.01

Everything works fine except the restful webservices. In SQL-WorkShop when i create a simple GET webservice and klick on "Test"" 404 not found" comes up in the browser.In the log i can see:

Request Path passes syntax validation
Mapping request to database pool: PoolMap [_poolName=apex, _regex=null, _workspaceIdentifier=null, _failed=false, _lastUpdate=-1, _template=null, _type=REGEX]
Applied database connection info
Attempting to process with PL/SQL Gateway
Not processed as PL/SQL Gateway request
Attempting to process as a RESTful Service
Determining if request can be dispatched as a Tenanted RESTful Service
Request path has one path segment, continuing processing
No Tenant Principal established yet, continuing processing
APEX_LISTENER pool exists, continuing processing
No matching tenant found for: ifc, cannot dispatch
No candidate found for: GET ifc/certification in context: URL....

View 3 Replies View Related

Application Express :: Display No Results Found In APEX Page

Sep 5, 2013

I have a page with two regions the top region is an html region where users enter query criteria and generate an interactive report in the second region.  The second region only displays if there are results from the query in the first region. 

I would like to display a "No Results Found" message rather than a blank screen if there are no results found.  However, I don't know exactly how to do that.  I tried to do it in the Interactive Report region, however, once I added the Conditional display to only when exists rows in the Interactive Report from the query criteria.

View 4 Replies View Related

Application Express :: 4.2.1 With Standalone Listener 2.0 - RESTful Tests 404 Not Found?

Jan 9, 2013

I'm trying to setup a dev machine to run APEX with RESTful services ahead of using Oracle's Cloud Database. Using Personal Edition, APEX 4.2.1 and the 2.0 Listener is up and running in standalone more. The problem is when hitting 'Test' on a selected REST Resource Handler, it comes up with an APEX 404 not found error, such as on the example HR REST handlers and a new test one setup.

I've followed all of the APEX and Listener instructions, run apex_rest_config.sql, ensured the various users are unlocked and tried both http and https (even though I've added the no SSL flag in the Listener config per standalone instructions.

View 3 Replies View Related

Application Express :: Unable To See Items Of Detail Form In Master Detail Form In Page Details?

Oct 31, 2013

I created a master-detail form using wizard in oracle apex 4.2 Now I want to attach an LOV to one of the items of detail form, which is visible on the same window as of master form. To do so, I need to first find the item in detail page, details of which are not available in page definitions. I can see all the items of master form but none for detail form in "Page Rendering" section. 

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 :: 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 :: Modify Form Layout Of Existing Application?

Feb 22, 2013

I have to modify the Form layout of an existing application (Application Express 4.0.2.) where the data for each field is retrieved using SQL statements

Presently the form looks something like this and the Data for each field is rendered properly in this layout:

UNIT # :         123456
ADMISSION #: 2012101510         DISCHARGE DATE:                 ADMISSION DATE:
FIRST NAME:   JON                     LAST NAME: DOEFIRST NAME, LAST NAME and UNIT # are all "Display Only" item type.

What I'm trying to do is to move "FIRST NAME" underneath "LAST NAME" and "UNIT #" next to "LAST NAME" This part is very simple. However, the issue I'm having is as soon as the "UNIT #" is moved next to "FIRST NAME", the data for "FIRST NAME" and "LAST NAME" simply disappear

This is how it looks
ADMISSION #: 2012101510         DISCHARGE DATE:                 ADMISSION DATE:
FIRST NAME:                             UNIT #: 123456
LAST NAME:   

I have played around for hours and even created from scratch a new page with a new form using SQL statements to pull the data for each field, only to get the same result.

View 7 Replies View Related

Application Express :: Running Jquery Code After Button Submits Successfully?

Jan 27, 2013

running a jquery code after submit button has successfully completed, how do i integrate these 2 events ? clicking the submit button and if submits successfully execute the small jquery code based on the same submit button

View 33 Replies View Related

Application Express :: Show Region After Running Dynamic Action Plsql?

May 1, 2013

i have a hidden region at the page top i want to show only after clicking my button which is running DA plsql code. This region is like a prompt message container/div at the top of the page so after few seconds like 10 secs i want to hide it again. I tried to use JQUERY but never hide it back, also i tried another TRUE CONDITION within my dynamic action but it doesnt reset it back the region is always shown...

View 2 Replies View Related

Application Express :: Possible To Upload Few Column In Table Through Data Loading

Jun 12, 2012

I have to do upload into the table through a csv file . The table's primary key i have to load the rest through user's uploaded file. Is it possible to do the data loading to the table only to required columns and fill the other columns from backend. Or is there any other way to do this?

View 1 Replies View Related







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