Hello:
I downloaded an application for Uploading CSV files to a table which Vikas had created. The application as is works perfectly.
For my needs, I want to do one more thing with the application. Right now, the application has you select the file, preview the file, and finally upload the file.
I want to eliminate the entire preview file portion. I just want to select the file and upload it into the table.
I went ahead and deleted the Parse File process and Preview button. This did not do the trick. When I run my application, I receive the following message:
ORA-00936: missing expression. I have looked at everything on the page to find the problem and I'm having a tough time seeing it. I also tried to use the Debug from the Developer's bar on the bottom of the page and I couldn't find the answer there either.
I have the application installed at apex.oracle.com. You can look at the application here: http://apex.oracle.com/pls/otn/f?p=32142:1
In case you need this info:
Workspace: HCB
User: TESTUSER
Password: test
The table is currently empty. Below is the data you can use to create a CSV file and try the browse and upload allowing you to recreate my error.
This is the data in the CSV file (test.csv):
col1,col2,col3
JANUARY,9900,3.2
FEBRUARY,1500,10.4
MARCH,2500,5.5
APRIL,3500,30.6
MAY,8000,20.5
Here is the SQL to create the table, if you need it, the table is already created:
CREATE TABLE "TEST"
( "NAME" VARCHAR2(10),
"COL1" NUMBER,
"COL2" NUMBER(10,2)
)
Can someone help me out?
Thank you in advance.