FAQ Database Discussion Community


Oracle APEX Date Filters Applied with apex_util.ir_filter

date,plsql,oracle-apex
I am using a dynamic action in my Oracle APEX application to apply date filters to my interactive report. The dynamic action is triggered by a change occurring in either my "Date From" (P4027_DATE_FROM) or "Date To"(P4027_DATE_TO) date boxes. The dynamic action submits both page items and contains one PLSQL...

Custom Event Dynamic Action based on $(document) jQuery selector

javascript,jquery,oracle,dom,oracle-apex
I've been using dynamic actions based on custom events in one of my Oracle Apex pages. I am binding my event to the document and then using a 'DOM Object' selection type (of document) in order to specify the context for the event. This works in Apex 4.2, however I...

Oracle Rest Data Services POST using JSON

oracle,oracle-apex,apex
I am using oracle rest data service in application express(apex). I need to know how to update/insert the database, using Json formatted http request. Actually what I need to know, A request is Json formatted request from REST client, { "items" : [ {"PROJECTID" : 1}, {"PROJ_NAME" : "rest"}, {"PROJ_CLIENT"...

Date Format Conversion In Apex

oracle-apex
I have a date item ' Order_TCD' in the form. My requirement is when user enters Order_TCD it should be in the format: DD-MON-YYYY HH:MIPM, But the data in the report should appear in the format DD-MON-YY. Kindly help. Thanks,...

jQuery show not executing when expected [closed]

javascript,jquery,oracle-apex
I have an APEX application with a button that is calling a javascript function. The function is doing some screen scraping and takes a few seconds to complete. I want to display a spinner icon first to provide the sense that something is happening. However, even though I have the...

What is the actual use of Oracle Application Express?

oracle,oracle-apex
What is the actual use of Oracle Application Express? After viewing several tutorials and videos, I came across that it is to make applications for Oracle RDBMS. If I am right, then is it possible to develop application without using Oracle Application Express?

apex tabular form icon link column

forms,oracle-apex,apex,tabular,tabular-form
I am working with a wizard-generated Tabular Form column that needs to display an icon which launches a Javascript function and pass the row value into the function when clicked. The function launches a popUp2 window which sets the values of other fields on that row. So the row number...

How to post JSON using Oracle Rest Data Services

oracle,rest,oracle-apex,apex
I am using Oracle regular database(not like NoSQL or something) with oracle rest data services. I need to know how to fetch the HTTP message body using pl/sql. For an example, send json object to the oracle application express through oracle rest data service, inside the application express expose the...

Oracle Apex 5 custom report

oracle,oracle-apex,oracle-apex-5
in my application I have a form based on a report with the list of Dishes. I want to change apperance of the report so that it doesn't look like a table, but more like a list. I don't want to have a heading. I would expect something similar to...

Oracle ApEX website

oracle-apex
I plan to create a website using Oracle ApEX and have a question regarding security, authentication. Most of the pages are going to be public to anyone, but some of them will require authentication. My question is that what is the guideline to handle this? If I enable an authentication...

How to determine the hostname in Oracle APEX?

oracle,oracle-apex
I want to create some links in Oracle APEX to the application itself. But it changes in my development envireonment and the production environment. I need a way to determine my current hostname and port. Which function can help me?

Add Extra criteria to Interactive Report Oracle Apex

oracle,plsql,oracle-apex
I need to add extra parameter to the interactive report for searching criteria. and I need it to be processed when I press the Go button in the interactive report. what I have is the text box but when searching the values entered never reflects in the report when I...

Counting multiple columns with the same criteria

sql,oracle10g,oracle-apex
I would like to count multiple columns based on their contents. Each column I want to count(alpha,bravo and charlie) has either 'T' or 'F', I only want to count those with a 'T'. So far i have: select t1.name, count(t1.alpha), count(t1.bravo), count(t1.charlie) from t1 where alpha='T', or bravo='t' or charlie='t'...

Select and Display the table in oracle APEX mail body

oracle-apex
Is it possible to select and display the database table in classic report manner in mail body while sending the mail in oracle APEX 4.2? Version : oracle APEX 4.2 SAMPLE : SAMPLE FORMAT FOR EMAIL Regards, DOC...

How do I display a new line within column data in an Apex Interactive Report

oracle-apex
I'm using Apex 4.2 and Oracle 11.g I have a column called "Transaction Detail" that I display in an interactive report. The report column's Display Text As selection is set to "Standard Report Column". The report column is selected from a varchar2 table column called transaction_detail. I'm just building the...

Oracle Apex dynamically enable/disable text field depending on LOV selected value

javascript,dynamic,action,oracle-apex,lov
I am trying to enable/disable text field depending on LOV selected value but it works just on page load, and I want to do it dynamically on client side when the LOV selected value change. I tried with a dynamic action but it only fire on page load. Any help?...

View based on apex collection

oracle,oracle-apex
in my application I have a view based on an apex collection: CREATE OR REPLACE FORCE VIEW "INGREDIENTS_VW" ("Food_name", "Weight", "Protein", "Carbohydrates", "Fat", "Calories", "Food_id", "Dish_id") AS SELECT c001 as "Food_name" ,c002 as "Weight" ,c003 as "Protein" ,c004 as "Carbohydrates" ,c005 as "Fat" ,c006 as "Calories" ,c007 as "Food_id" ,c008...

Oracle Apex 5 for web application

oracle,oracle-apex,oracle-apex-5
I have Oracle database development and PL/SQL background. Now I want to move towards web applications development. My dream is to create noncorporate web application for diet/training management with big focus on integration with experts, catering services/individual cooks, food shops/markets. Very general description of an idea: Diet management (plans, dishes...

Create Image Button in Oracle Apex 5

css,css3,oracle11g,oracle-apex,oracle-apex-5
How can i create Image Button in Oracle Apex 5 ? I am using Universal Theme in my application. I have set Button Attributes as below. But it display like this. UPDATE After using style="background-image:url(#APP_IMAGES#holidays.png);background-repeat:no-repeat;" in Button Attributes field, image display like this. Instead of full image it displays cropped...

Identifier 'EXTRACTVALUE' must be declaredCompilation failed

oracle,plsql,oracle11g,oracle-apex,plsqldeveloper
I tryed to retrive xml data to variable but giving me error saying "identifier 'EXTRACTVALUE' must be declaredCompilation failed" VarConverstionFact NUMBER; BEGIN VarConverstionFact := TO_NUMBER(ExtractValue(PXML, '/OBJECT/Item/ItemUomLevelsList/ItemUomLevels/ConversionFactor')); IF VarConverstionFact > 0 THEN SELECT BIZZXE_V2_SCH.SQ_ITEM_ID.NEXTVAL INTO varID FROM DUAL; END IF; END; This is save xml nodes <Item> <LocationId>0</LocationId> <Id>0</Id> <ItemId>0</ItemId>...

Passing data in Apex Pages

html,sql,oracle-apex
I want to pass the data from one page (a form) to another without actually adding the data to the database. I will use the 'next' button to pass the values (data) and 'submit' button to insert all the details from previous pages to the database. Does anyone know how...

ORA-00913: too many values with a nested case

sql,oracle,oracle11g,oracle-apex
I am currently working on my first year assignment to build a database using Oracle Apex and am trying to create a report with fields to filter the table displayed. To do this using 2 parameters (in this case date of a dentist appointment and the staff member performing said...

Build an APEX URL that pulls in the APP_USER ID

oracle-apex
I am using a PL/SQL Region in APEX where I am build an Interactive Report Link that will filter the report for the USERs :APP_USER id and provide them a view of their rows only. The Region first counts the rows to show the user how many rows he/she has...

Slow loading in IE, chrome; fine in FF and Opera

javascript,google-chrome,internet-explorer,oracle-apex
I've been developing an intranet application in APEX (accessed via the IP, port, and application number, like 10.1.6.94:8087/apex/f?p=937). The problem is, when I had my coworkers test it, they ran into all sorts of problems because the javascript and other resources on the page were loading very slowly. They're all...

PL SQL Retrieve Table data to XML TYPE

sql,oracle11g,oracle-apex,appendchild,xmltype
I wanted to know why my data is not filter in 3rd level by 2nd level primary key. In first level i'm passing Item Id as a PREFNO then after i'm retrieving data according to ITEM_ID. 2nd level finding primary key of LEVEL_ID using ITEM_ID and retrieving Dimensions according to...

Comparing dates using Dynamic Action on DatePicker Oracle Apex

oracle,dynamic,datepicker,action,oracle-apex
I have a date picker where the user simply chooses a date then a Dynamic Action is suppose to send an alert if the user clicks tomorrow(sysdate+1). The Datepicker term is the simple layout. The Dynamic Action--> Name: Valid Date Event: Change Selection type: Item(s) Item(s): datepicker_name Condition: equal to...

How to refresh a select list when another item is changed by a dynamic action?

ajax,plsql,oracle-apex
I am using Apex 4.2 and Oracle XE 11G. I have a fairly complex page but have created a simplified version and imported it into apex.oracle.com and hope someone can suggest the problem. Note the design may appear a little strange due to the parts i have removed but i...

How to insert time into a DATE type?

sql,oracle,oracle-sqldeveloper,oracle-apex
I inserted a tuple using the TO_DATE function, but it turns out to be '05/01/2015' when I do the query. There is no time shown. Anything is wrong? INSERT INTO course_section VALUES(1,'MWF',TO_DATE('10:00:00 A.M.','HH:MI:SS A.M.')); How to fix it?...

Error: pls-00103 encountered the symbol “<”

javascript,plsql,oracle-apex
I have an error in my Procedure code in Oracle Apex. PLS-00103 encountered the symbol "<" I think this is saying that it is not recognizing the JavaScript for Google maps, but I'm not sure. I'm trying to create a procedure to be called by PL/SQL, in oracle apex, to...

Query value from APEX page item

oracle,oracle-apex
I'm querying two tables to display values in a tabular form on page two, based on a row selected on page one, (the data on page two is editable, relevant to the column on page one.) I created a hidden item on page two to hold the unique identifier from...

Invalid SQL Statements on “DEFINE” commands Oracle Database

oracle,plsql,define,oracle-apex
I am new in oracle, and when I am trying to use define command, I'm encountering ORA-00900: invalid SQL statement error. This is my code : DEFINE p_num1 = 2; DEFINE p_num2 = 4; declare b1 number(7,3) := &p_num1; b2 number(7,3) := &p_num2; v_cont number(7,3); begin v_cont := &p_num1/&p_num2; dbms_output.put_line(v_cont);...

Negate a bind variable

sql,oracle11g,oracle-apex
I am using APEX 5.0 and I have a query such as: Select * FROM table where condition = :BIND_VARIABLE I have a list which dynamically fills in the bind variable. The list has two values which the bind variable can take: Value 1 Everything except value 1 'Everything else'...

Exclude numeric values from report

sql,oracle,oracle-apex,regexp-like
I have a field named statu in the table TB_ORDERS. If the field status has a numeric value, I should exclude that record from report - only alphabetical should be shown. How do I do that?...

How to use Regex_Like for this case?

sql,regex,oracle-apex,regexp-like
I have a field named Order_ID from table Order. when value of Order_ID starts with numeric value then it should exclude those records, otherwise it should include those records in the report. For example: if the Order_ID starts with a value 1ABC it should exclude that record from report ....

How do I substitute values from a second table (multiple times) in a single query in Oracle SQL/APEX

oracle11g,oracle-apex
Suppose I have an employee table “DB_EMPLOYEE” with the following values for EMPID and NAME EMPID NAME 0 Bob 1 Joe 2 Carl 3 Wendy Next, I have another table listing audits, “ICQA_AUDITS” with the following values for the columns RECORD_ID, AUDITOR_ID, PACKER_ID, SHIPPER_ID RECORD_ID AUDITOR_ID PACKER_ID SHIPPER_ID 0 0...

Including Alert message for my Dynamic Actions

oracle-apex
I have a set of text Field items in oracle apex: Order Number Revision Number When we open the report, revision should be hidden. Only when the user enters unique order number (non-duplicate order numbers), revision number should be visible. If he enters duplicate order number, revision number should be...

Apex: How to find out the schema name?

oracle-apex,apex
I need to find my schema name because i want to delete triggers which i created. For example the following: CREATE OR REPLACE TRIGGER TRIGGER_ORDER BEFORE INSERT ON HOUSE_ORDER REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW WHEN (NEW.ORDER_ID IS NULL) BEGIN SELECT SEQ_ORDER_ID.NEXTVAL INTO :NEW.ORDER_ID FROM DUAL;...

Google map disappearing in APEX region

plsql,oracle-apex,procedure,geocode
I'm trying to display map in one of my apex pages region, this map will have draggable marker which links to text-fields on other region and displays geocode for latitude and longitude. Everythings works except one thing the map is appearing just for 0.5 second and disappears. I think the...

Oracle Query on Comma Separated Values In a Column

sql,oracle,oracle-apex
I have two tables. One table is a list of access points. The other is a list of who has access to what. It use to be a person had access to either one thing or all things. But, now that has changed. Now someone might have access to several...

Why does APEX submit when I press Enter when I never programmed it to?

oracle,oracle-apex
I discovered this behavior in Oracle APEX 4.2: you create a page with form elements and now when you press Enter in a textbox (text field), the page submits, even though you have "Submit when Enter pressed" set to No and haven't made any dynamic actions or other javascript checking...

PL/ SQL Loop No data found

sql,plsql,oracle11g,oracle-apex
I tried to take values for VarNewIdOne as a bulk collection. So i got values to bulk collection after i tried to equel that values to another variable (VarOldLevlIdOne) then getting out put as a NO data found. SELECT ITEM_ID bulk collect INTO VarNewIdOne FROM BIZZXE_V2_SCH.ITEMS WHERE PARENT_ITEM_ID = VarId;...

PL/SQL process: issue with wording

oracle,stored-procedures,plsql,oracle-apex,apex-code
I am trying to create a page process in Oracle APEX 4.1. Specifically, When a button on this page is process submitting the page, I want this PL/SQL query to work. I don't have much of an understanding of PL/SQL and am looking to find out how to figure this...