Dear All,

I just started learning APEX and am stuck with an error message.

1 - I installed Oracle Database 10g Release 2 Express Edition (XE) on my local PC with Windows XP SP 3
2 - Upgraded the APEX to 3.2
3 - The book I am using is "Beginning Oracle Application Express - 2008"
4 - In the lesson the author uses

UTILITES > DATA LOAD/UNLOAD > LOAD > Load Spreedsheet Data

Load to : New Table
Load From : Upload file
Borwse for File "Order" Microsoft Office Excel Comma Seperated Values File
Table Name : ORDERS
Primary Key Column : Create New Column as ORDERS_PK

If this is done with APEX 2.1 it works but with my uprade to 3.2 I get the following error.

"ORA-20001: create_table error: ORA-20001: Excel load run ddl error: ORA-01003: no statement parsed"

Any help will be much appreciated.

Thank you for replying. My first name is Jawad and I have updated my profile.

1 - I have knowledge of the Relational model theory, data modeling, database design (academic & theory) but only have experience with the desktop DBMS MS Access.
2 - Want to migrate from MS Access to Oracle.
3 - Got this book called "Begning Oracle Application Express"
4 - Want to develop a fully finctional application for 50 users for a company for ORDERS entry & INVOICE raising.
5 - There are no other developes as I am the database modeler, designer and application developer.
6 - Prepared the conceptal model and the logicl model.
7 - Want now to develop the application and deploy it.
8 - All the above are hypothetical which i am using to learn.

Here is what I did.

1 - Installed Oracle Database Express Edition (XE) Release 2 on my local PC with Windows XP Professional SP 3 supplying the password for SYS and SYSTEM as per the video at
http://www.mandsconsulting.com/oracle-xe-install-tutorial

2 - Upgraded the Oracle Application Express to 3.2 as per the video at
http://www.mandsconsulting.com/install-oracle-apex-32-on-xe-and-xp-pro-video-walkthrough-tutorial

Befor the upgrade the Orcale Database 10g Express Edition came with APEX 2.0 (& something) as it shows at the bottom on the screen once you log in as SYSTEM. After upgrade the same changes to Application Express 3.2.0.00.27

I can not use hosted account as I am not connected to the net all the time.

Now after every thing done, I log in as
Workplace : SYSTEM
User : SYSTEM
password : ***********

It takes me to the home page with Application Express 3.2.0.00.27 showing at the bottom right of the screen. Now as per the book

1 - Click utilities
2 - Clik Data load/unload
3 - Click load
4 - Click load spreedsheet data
5 - Change the load from to 'upload file (coma seperated and tab delimited' & NEXT
5 - Browse fo rthe file ORDERS.csv & NEXT
6 - it shows Schema "SYSTEM"
7 - I gaive the table name as "ORDERS" & NEXT
8 - Change the new primiray key to "ORDERS_PK" & click LOAD DATA

And i get

"ORA-20001: create_table error: ORA-20001: Excel load run ddl error: ORA-01003: no statement parsed"

I also tried making a new user while loged in as SYSTEM

1 - Loged in as

workpace : SYSTEM
User : System
Password : **********

2 - Click Mange Application Express Users
3 - Click Create
4 - User name : Jawad
password : ***********
confirm password : **************
email : jawadasgharali@yahoo.com
Accessible Schema (null for all) : (left null)
Default Schema : SYSTEM
User is a develper : YES
User is a worspace administartor : Yes
Set Account availibility : Unlocked
Require chage of password on first use : No

So now i created a new user called Jawad who is a workpace administartor

I log out from SYSTEM and log in back as Jawad

Workspace : SYSTEM
User : Jawad
Password : *********

and now i do all the things again to upload the data and i get the same error message.

I think some thing to do with Workpace, Users, Schemas, and tablespace capacity. But i have no idea about them.

I tried complete uninstall and re-install and it works fine with the default APEX 2.0, but there is much difference between APEX 2.0 and APex 3.2 and the book uses the APAEX 3.2.

Regards

Jawad

Scott,

Thanks Scott. Please excuse by lack of knowledge as i am totally new to this.

If I am doing this right. I log in at

1 - http://127.0.0.1:8080/apex - This is for the Oracle Database 10g Express Edition (XE) home page which shows
Workpsace : SYSTEM
User : SYSTEM
Password : *******

The above is to manage the Oracle Instance?

2 - http://127.0.0.1:8080/apex/apex_admin - This is for the Oracle Application Express home page which shows

"Using this interface the administrator can manage all aspects of the service including creating, removing, and managing workspaces."

"Application Express Administration Services"

Username : ADMIN
Password : ***********

The above is to manage the APEX instance?

But now I get the error

"Access denied by Application security check"

"Application access restricted to internal workspace users."

Return to Application

Jawad

Thanks. Problem solved

Needed to log in at http://127.0.0.1:8080/apex/apex_admin

Create a new work space

Works now