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


ADVERTISEMENT

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 Listener :: How To Upload File Using Restful Service

Feb 4, 2013

I want to upload file using restful service This is my code to send file to rest service

MultipartEntity reqEntity = new MultipartEntity(HttpMultipartMode.BROWSER_COMPATIBLE);
FileBody bin = new FileBody(f);
FormBodyPart bodypart = new FormBodyPart("file", bin);
reqEntity.addPart(bodypart);

[code]...

But how can i retrive at server side in restful service using plsql?

View 0 Replies View Related

Application Express :: 4.2 Upgrade - Static File Upload Mim - Type Error?

Apr 17, 2013

After Upgrading to Apex 4.2

When uploading a static text/javascript file (i.e. filename = 'thisFile.js') the file Mime Type defaults to 'application/octet-stream' (instead of 'text/javascript'). This issue occurs in I.E. 8 but not in Firefox.

View 0 Replies View Related

Application Express :: Unable To Upload CSV File Through 4.2 (Blob) To Oracle Table

Jan 4, 2013

I needed to create a page on my existing APEX application that would allow the user to upload a file, I followed an online tutorial where the user had created a dummy table and inserted CSV File inserted through APEX into the table. Following that simple example I am able to load the simple CSV file (from tutorial) into a dummy table (from tutorial) but when I attempt to insert actual/dummy data into my actual database (which has a lot more fields of different types), using the exact same process, I am unable to do so.

Ironically, I am unable to insert even dummy values despite the fact that I have been able to insert the same dummy values using SQL Developer. Icing on the cake is that APEX does not produce any error, this lack of debugging feature (especially line by line debugging) is such a pain. Just to add, I can load the values into an Array and can successfully print the delimited values off the array but am still unable to insert the same values into my table. Here is the table that I am attempting to insert into (actual names replaced by Dummyxx):

CREATE TABLE "TABLE"."STG" (
"DUMMY01" NUMBER,
"DUMMY02" NUMBER,
"DUMMY03" NUMBER,
"DUMMY04" DATE,
"DUMMY05" CHAR(3 BYTE),
[code].........     
                           
And here's the insertion process:

DECLARE

v_blob_data BLOB;
v_blob_len NUMBER;
v_position NUMBER;
v_raw_chunk RAW(10000);
v_char CHAR(1);
[code]..........

If I run a process to produce the output of the data array onto the screen, the values displayed are in the pattern desired.

Inserting Dummy values instead of values from the Array (v_data_array) to test

EXECUTE IMMEDIATE 'insert into TABLE.STG (DUMMY01, DUMMY02 ..... DUMMY65)

VALUES (
60040,
5,
TO_DATE("14-Dec-12","DD-MON-RRRR HH:MI:SS"),
"ABC",
"ABC",
60,
"11DEC1201",
"331",
"SCOTT TIGER",
"MARKETING",
[code].......

Note that all the the CSV does not contain all the fields, the CSV files that are expected to be entered into the system contain 65 Fields whereas the Table has 73 Fields. Also note that the process runs fine through SQL loader that is invoked through a different server which I need to release and hence the attempt to load the table this way. Also, the procedure on the SQL Loader server is quite complex and involved JAVA+Unix Shell Scripts etc. which I would prefer to avoid.

View 1 Replies View Related

Application Express :: Direct File Upload From End User Machine To Sftp Server?

Sep 19, 2012

I want my application to provide an end-user with ability to upload the files from their machine to SFTP server directly. So far, I have managed to write the function which uses java source and allows to upload files from the database. It works just fine.

The function looks as follows:

FUNCTION SFTP_CMD (
V_USER IN VARCHAR2,
V_PASS IN VARCHAR2,
V_HOST IN VARCHAR2,

[code]..

where V_FILE_SRC represents location of the file to be uploaded. The thing is that the FILE BROWSE apex item does not allow to specify the file location, it identifies it somehow automatically, when you press the button 'Choose file'. The question is how can I catch file's path, so that I can pass it to V_FILE_SRC parameter in my function? Should I write my own plugin? or hack FILE BROWSE item? =)

View 2 Replies View Related

Application Express :: BLOB Action - Implement File Upload And Download Function

Sep 11, 2013

In my project, I implement file's upload and download function by  "BLOB Support in Forms and Reports" of  official development document Advanced Programming Techniques When user click the BLOB column to download file, I want to trigger an action to update one table  for counting this file is downloaded one more times. But I can not find any "dynamic action" about this Blob column of Report.

View 1 Replies View Related

Application Express :: Upload Wizard In 4.1

Feb 25, 2013

We are using APEX 4.1. When we try to upload data to a table through upload wizard, even if the record is an update , it still shows "Insert" and then fails with "Primary Key violation" error. We have defined the correct Primary key at table and APEX interface.

View 3 Replies View Related

Application Express :: Upload And Download BFILE

Sep 12, 2012

Is there any way to upload a file to APEX as BFILE instead of BLOB? I need it to be BFILE since I will be only using XE which means I have limited data storage and unfortunately the system will allow users to upload and download files of different formats (.exe,.bat ) etc. which can be as big as 10MB. Also, how to download these files considering the authentication of the application.

View 3 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 :: Upload From Excel For Several Tables

Jan 7, 2013

Pretty new to APEX and was hoping to accomplish with native functionality.

Using the latest APEX, there is nice functionality that creates a wizard for you for a single table. I wanted to have a single wizard but pick a table then have the ability to map my fields for insert/update.

View 2 Replies View Related

Application Express :: Upload CSV Files To Table Using 3.2 Version

Jul 30, 2013

Using Apex 3.2 version , Need to  Upload .CSV Files  to the Table (T_UPLOAD),

View 11 Replies View Related

Application Express :: Upload Just One Xls Sheet When Using Xls2 Collection?

Oct 25, 2012

in our application, we're uploading .xls files with several (and heavy) sheets.

In order to get better performance, is there any way to load just one of them?

View 0 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

Application Express :: ORA-00997 / Illegal Use Of LONG Datatype

Jul 26, 2012

I am trying to copy structure of table through database link but getting an error while running the command :

SQL> create table TOAD_PLAN as select * from TOAD_PLAN_@db_link where 1=2;
create table TOAD_PLAN_TABLE as select * from TOAD_PLAN_TABLE@to_paceview where 1=2
*
ERROR at line 1:
ORA-00997: illegal use of LONG datatype

how can i create it through database link or through any other utility.

View 2 Replies View Related

Application Express :: Link Local File With Browse File Dialog

Aug 15, 2012

I'm looking for a solution to hyperlink to a local file (i.e. C:/test.txt). I want that the user clicks on a "browse file" button like the file browse item. after the user selected a file or just a folder the path should be shown in a display only item. this item should be clickable...

Is it possible to create a "Browse file" dialog? I know that to link to a file is possible with some HTML tags in the "pre element text" and "post element text" fields. something like "<a href="... but I don't know how this works.

View 2 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 :: How To Change File Character When Export Application (4.2.1.00.08)

Feb 5, 2013

I need to change "File Character" when I export application with Apex 4.2.1.00.08 version, but this option, is not possible. The ComboBox already select with

"Unicode UTF-8]', but I need "ISO-8859-1 - Europa Ocidental",

how can I do change it?

View 1 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 :: 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 View Related

Forms :: Upload File In Ebs 11i?

Oct 8, 2013

oracle forms 6i
oracle ebs 11.5.10
database 9i

i create new custom application in my ebs 11i and i want to upload file in our custom application and save it as file system in my server lunix

how i attach my file and i want to save it not as blob but just upload to my server and after download it?

View 2 Replies View Related

SQL & PL/SQL :: Upload Word File

Aug 9, 2010

i want to upload a word file to database.I wrote the following code

create or replace directory MY_FILES as 'C:Uploadfolder';

Create table emp1(
EMPNO number(30),
EMPNAMe varchar2(10),
RESUME BLOB);

[Code]....

ERROR at line 1: ORA-22288: file or LOB operation FILEOPEN failed No such file or directory ORA-06512: at "SYS.DBMS_LOB", line 523 ORA-06512: at line 10

View 32 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 :: 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

Drop Statement On Table Taking Long Time

Sep 20, 2010

We are firing a normal Drop command on our database and the database version is 10.2.0.4.The database is running on AIX v5.The command is taking more time than usual .

When i am monitoring the session i can see that a call is being made to procedure "aw_drop_proc".Could i ask you if this is something that is taking more time than usual.

We are not having any partitions on the nested tables .We have a pack of tables and we are dropping this pack through a procedure.The pack comprises of nested tables & normal tables.To drop a nested table it is taking around 6 seconds(Table with no rows) and a normal table(With no rows) it is taking 17 milli seconds.We have a partition on Normal table.

The same operation in windows is taking very less time when compared to AIX.

View 5 Replies View Related

SQL Queries Taking Long Time After 11g Data Migration

Sep 14, 2010

I have upgraded oracle database from 9i to 11g using export and import utility. After migration we are facing performance issue in report generation, We have observed that First execution of report is taking very long time and when we generate the same report 2 -3 times there is considerable change in the execution time and it is more better than the first execution.

2 days back I have restarted the database and found the same issue. There are around 300 Reports and it is not possible to generate all the reports 2-3 times every time we restart the database.

View 5 Replies View Related

Forms :: Upload PDF File To Server

Jan 23, 2013

I'm using oracle 10g and Forms 9i . I need to upload a PDF file from client to server no to database, just like File, is there any way to get it, no webutil using.

View 1 Replies View Related







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