Apex_Application_Files (WWV_FLOW_FILES) in Apex 3.0.1

10-11  Source: Network gathering  Views:0 

Advertisement
Hello,
We are currently using 3.0.1 of Apex and have been using the Apex_Application_Files view to upload files from Apex.
What I don't understand is, when looking at the details of this view I notice that NAME is VARCHAR2(90) and the FILENAME is VARCHAR2(400) and what I am wondering is can I ever get a filename that will be over 80 odd characters?
As I have been looking at my data and I notice that the values in the NAME field seem to be F(some random number)/filename so that is why I am asking if my filename should be no more than 80 characters?
I have tried uploading a file with a filename of 90 characters and all I am getting a 404 Page not found, The requested URL /pls/htmldb/wwv_flow.accept was not found on this server.
I have tried putting a validation of checking the length of the filename but that is not even getting called.
Cheers,
Paul.
Here is a good post on how to use JavaScript to test the name before the page is posted. http://www.oracleapplicationexpress.com/2009/04/file-browse-filename-length-limit.html
I think the page validations get called after the internal Apex process tries to load the file data.
Greg
Related articles
  • Apex_Application_Files (WWV_FLOW_FILES) in Apex 3.0.1 10-11

    Hello, We are currently using 3.0.1 of Apex and have been using the Apex_Application_Files view to upload files from Apex. What I don't understand is, when looking at the details of this view I notice that NAME is VARCHAR2(90) and the FILENAME is VAR

  • APEX BFILE 10-11

    I have to store graphical documents in an Oracle Database using Apex. I have designed an application based on the Sample Application for Customers, Product, Orders Page 3 and 6 using apex_util.get_blob_file_src and a File Browse Item to store the doc

  • Please help, I need to read blob and output in bytes from wwv_flow_files. 10-11

    Hi all, I am having a requirement to read a blob stored in the oracle table and convert it into bytes. I am loading this table (wwv_flow_files) with APEX. The code under page 1 is as follows: DECLARE z number; y varchar2(4000); x varchar2(400); b blo

  • File Browse Validation not stopping upload 10-11

    Hi Guys, I am using Apex 4.0 and need help with the following please: I have a file browse item which uploads a file into the built in WWV_FLOW_FILES. The problem is it uploads even when there is an error and my validation flags up. Is it supposed to

  • Plesae help- needing to read a blob from db into bytes[] 11-30

    Hi all, I am having a requirement to read a blob stored in the oracle table and convert it into bytes. I am loading this table (wwv_flow_files) with APEX. The code under page 1 is as follows: DECLARE z number; y varchar2(4000); x varchar2(400); b blo

  • Using File Browse to update stored file 10-11

    Hi all, I have a form with a File Browse item on it which is (surprisingly!) used to upload a file and associate with a record. The filename is stored in a varchar column in the table. This works fine when I create (INSERT) the initial record and I c

  • How to SCAN uploaded files for VIRUS in APEX 10-11

    part 1: Goal: Do a virus scan of the uploaded file from APEX application prior to storing the file in custom tables. The process: Followed the document from www.developer.com: Implementing an Anti-Virus File Scan in JEE Applications By Vlad Kofman Go

  • File upload to sftp server using apex 10-11

    We have an SFTP server on Linux and we want to provide users with web-based interface (Oracle APEX has been chosen for that purpose) so they can upload their flat files to our sftp server via secure transmission. is it possible to implement on APEX?

  • File not showing in wwv_flow_files 10-11

    After upgrading to APEX 4, my file browse items aren't being written to the wwv_flow_files anymore. In my Page process, the code below is returning 'No data Found' errors. DECLARE p_owner varchar2(30) := '#OWNER#'; p_user varchar2(30) := :APP_USER; p

  • Full path and filename in wwv_flow_files after upload from UNC path in IE 10-11

    I have a page with a file browse item. After page submit I move the file from wwv_flow_files to another table. Normally the column wwv_flow_files.filename only contains the filename. However, when using IE9 and selecting a file from an UNC path the c

  • APEX_APPLICATION_FILES: ORA-00942: table or view does not exist 10-11

    Hello, As my first APEX task I am attempting the upload/download demo on http://download.oracle.com/docs/cd/B32472_01/doc/appdev.300/b32469/up_dn_files.htm The ultimate goal is to store PDF files in the database. In order to complete step 1: To creat

  • Uploading multiple files into wwv_flow_files. 10-11

    Hi, I've been happily using the apex file browse button functionality to upload files into the wwv_flow_files table and moving them over to my app specific tables for some time now. I was wondering; Is there a straight forward way of uploading all th

  • How to get all image files from a folder to wwv_flow_files? 10-11

    Hi there! Is it possible in apex to show, in a report look-a-like, all image filenames from a folder in another machine (i enter in that machine by ip) and insert all files into wwv_flow_files? I want to see all files, then pick one and open a image.

  • APEX Listener and EPG - strange behaviour 10-11

    Hi For some years, I've used EPG for APEX but have struggled with performance particularly as I can have up to 150 student developers using at any one time. I do a fair amount of work using ORDImage and have successfully developed APEX applications t

  • No Data Found Error in wwv_flow_files 10-11

    Hello All, I have written a procedure to upload the .csv file data into one of my database Table. It was working fine some days back, but when I try to upload a .csv today, it gives me error "No Data Found". This is the Query I am using to fetch

  • How Can we move files from apex database to third party database (i.e. Google drive) 10-11

    Hi All, I am storing the files in apex database which are uploaded through apex form. Now i want to move these files to the third party server on regular bases. Means once we stored those files in our apex database at specific time on everyday we hav

  • Dump data from a table into wwv_flow_files 10-11

    HI, Could you help me, to take data from a table, and insert it into blob_content in wwv_flow_files; and data should be stored in a .txt file regards, RajeshAlex Nuijten wrote: But in case of APEX, that might be a really bad idea to insert metadata i

  • Library Cache Pin Wait Event (within the context of APEX) 10-11

    Hello, Firstly - Oracle Version: 10.2.0.4.0 Apex Version: 3.0.1.00.08 Okay, my colleague (no really! This isn't one of those "Ahem ... A friend of mine has contracted something nasty +downstairs+..."-type questions) is having problems compiling

  • Accessing wwv_flow_files changed after upgrading from 2.0 to 2.2 10-11

    We have recently moved to 2.2 After the move uploading files, under some circumstances, failed. Further investigation found that the upload was working fine, accessing wwv_flow_files table had changed in some way. From the SQL Workshop we could see t

  • Download pdf into browser, object not stored in wwv_flow_files 10-11

    Was wondering if you’re able to help? I want to view a pdf I’ve stored in a blob column via APEX. I can view pdf’s I’ve uploaded and stored via apex i.e. stored in wwv_flow_files, but not objects stored in other tables. To help see what I’m doing I w