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.

JAA149:
Question: Are Oracle 10g Express 2.1 and Oracle 10g APEX 3.2 on the same machine?

I also have Oracle 10g with Database Express Edition 2.1 running Windows XP Professional on my personal laptop. Before running the 10g, I:

• Stop all other database Services that are running when I boot-up, like MS SQL;
• Next, I start the Oracle 10g Database;
• Log In using the System Admin Username created during the Oracle 10g install.

If you are using a username different from the System Admin, make sure you have ALL the SAME priviledges as the System Admin.
I have yet to upgrade from 2.1 to 3.2 the current version, because I am not sure if I must first upgrade to 3.1, then to 3.2. I used the Oracle Hosted Account with much success, once I complete the book, then I will upgrade.

Hope this Helps.

__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

Dear Peace 95,

Thank you very much for answering. You do not know how it is to be like lost in a jungle and find another human being. The jungle being the metaphor for stuyding the book. I have posted the same question on the OTN Application express forum as well as on the OTN Database 10g express edition forum with no results. Just views of hundreds and no reply.

http://forums.oracle.com/forums/thre...24117&tstart=0
http://forums.oracle.com/forums/thre...24058&tstart=0

As the book says I am migrating from MS Acccess to oracle. However I am well veresed in Relational Databse Theory (Academic) and its underlying maths (Set theory and logic) as well as Database modeling and design (theory) but do not have experience on any RDBMS other than MS Access. Also have novice famililarity with SQL.

That aside, I am now lost since one week with 10g. Here is what I did.

1 - Installed Oracle Database Express Edition (XE) Release 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

2 - Now I log in as
WORKSPACE : SYSTEM
USER NAME : SYSTEM
PASSWORD : ********

3 - Go to Utilities > Data Load/Unload > Load > Loadspreadsheet Data >
Change the Load from to upload file (comma seperated or tab delimited) NEXT
Browse for the file which is 'ORDERS', NEXT
Change the table name to 'ORDERS'
Change the primirary key column to ORDERS_ID - LOAD DATA

And than i get

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

Forigive me for my ignorance as I am a newbie. As far as I know, when I installed the Oracle Database 10g Express Edition, it also installs with Oracle Appplication Express 2.1.

I have read all the Orcle documentation for the upgarde as also as per the video I am able to upgrade to APPEX 3.2 with out any problems. The User account SYS and SYSTEm is the same with my password and I use them to log in. When upgraded, at the bottom, when you log in, the page says Application Express 3.200.some thing. So no problems there.

How are you able to folow the book with Apress 2.1. The reason I upgraded to APEX 3.2 is that, that is what the book uses to teach.

Also I can not use hosted APEX account as I am not always on the net. My aim is to learn making for example a complete working application for example for 20 to 50 users on a LAN. Just to learn how to give them a fully developed software for example for ORDERS and BILLING running on a WINDOWS XP network.

How to i go about setting the APEX 3.2 to be used with the book. The APEX 3.2 is veru different from APEX 2.1. I just want to lets, say make a new Workspace, A new USer, new Schema and start doing the excersises in the book.

I got so frustated, that I uninstalled every thing and reinstalled again. Now a new problem. When I try to upload data, NO SCHEMA is showing.

As i said, I am totally new to this and MS Access approach is very different from Oracle. But a week just to install oracle and not able to get beyond the first chapter?

Please if you have any suggestion I would greatly appreciate it. Some thing like step by step instructions. I know it's a lot to ask, but i have no options.

Regards

Jawad

Dear Peace 95,

Thank you for answering. You do'nt how how it to be like lost in jungle and finally see another human being.

Following is the exact steps i followed.

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 come 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"

As i said I am totally new to this and migrating from MS Access. However I am quite familiar with Relational Data model, Databsae Modeling, Database Design, SET theroy & Logic (Academeic & theory) but no experience with DBMS other than MS Access. Begginers knowledge with SQL.

My objective is to make a fully functional application for 50 users in an organization for ORDERS ENTRY & INVOICE Raising. The network is all Windows XP Professional SP3.

Just want to ge ahead and start studying the chapter 2. But since a week I am stuck here.

1 - I can log is SYS
2 - i can log is SYSTEM

through http://127.0.0.1:8080/apex

Do not know much about 'Run SQL command line".

What do i do? Do i create another USER loging in as SYSTEM and then try?

There is no network and other developers. I am doing every thing to produce a fully functional applications. But i can not seem to get through the 2nd chapter of the book.

Before i updated the Apex 2.0 to Apaex 3.2, i could see the user 'HR' but after update the 'HR' and its tables also disappeared.

I have upgraded to APEX 3.2 because that is what the book uses so i can follow along. How are you able to follow the book with you default APEX 2.0?

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 : [email protected]
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 to do with Workpace, Users, Schemas, and tablespace capcity. But i have no idea about them.

Will be much appreciated if you can state the exact step by step instructions on how you got going. 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 PAEX 3.2.

Regards

Jawad

JAA149:

We have all been there at one time or another... Hang in there and don't give up.

The problem is what you did in your last step with ORDERS_PK.

ORDERS_PK is the response to the PK Constraint Name and not the Primary Key Name, which is ID...automatically selected.

Are you getting Figure 2-6? It sounds as if you were.

Try this first, then I will address the other.

Hope this helps.

__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

I am trying to post here. I just spend 2 hours poting here and it does not show up. My last 2 posts also had the same error. That caused a repeat. Is there some delay of the actual posting of it.

Checking if post working

Right than. Now it works but the one i spend 2 hours on has disappeared. Guess have to do again.

I follows these steps

1 - log it with http://127.0.0.1:8080/apex
http://i32.tinypic.com/wb6stw.jpg

2 - The APEX version now has changed from the default 2.1 to 3.2
http://i26.tinypic.com/v5g03k.jpg

3 - went to load from
http://i28.tinypic.com/2411i1k.jpg

4 - Browsed the ORDER.csv file
http://i30.tinypic.com/e06ekp.jpg

5 - Set the table name to ORDERS
http://i30.tinypic.com/20p1ziw.jpg

6 - Set the primary key to ORDERS_PK
IMG]http://i30.tinypic.com/28iqfeh.jpg[/IMG]

7 - And i get the error
http://i28.tinypic.com/11kf9fc.jpg

This is done exactly as per the book. If i do like this at step 6
http://i26.tinypic.com/123urea.jpg

I still get the same error as per the image at step 7

The help at Application Express Forum Says

http://forums.oracle.com/forums/thre...4058&tstart=15

I will now try to log in at

http://127.0.0.1:8080/apex_apex_admin

and do some thing there. I do not know. Am i right in thinking that

http://127.0.0..1:8080/apex is the home page for Oracle Databse 10g Express Edition (XE) to manage th "ORACLE Instance" what ever that means

AND

http://127.0.0.1:800/apex_apex_admin is the home page for Oracle Application Express 3.2 to manae the "ORACLE Application Express" instance?

I am at chapter 2 from figures 2-2 to 2-7. Everything works fine till 2-6 and than the error

Should i just try to read and learn the book with the default APEX 2.1. But the book uses APEX 3.2 (which includes the workspace) and is quite different frm the APEX 2.1. How are you able to do it.

Regards

Jawad

Jawad:

It seems you should, as Scott suggested, create a new workspace other than SYSTEM and start over.

I also suggest not to use 10g's 2.1 version, because the screens are very different and therefore you would have nothing to compare. I loaded the ORDERS table into my 10g 2.1 and the screens are different. The Figures in the book are using APEX version 3.1, BUT the Figures or screen shots from 3.2 are the same and I am on Chapter 9.

All you have to do is take your time...the Primary Key Name is ORDER_ID not ORDERS_ID. This is important this table is used throughtout the book and in SQL scripts so you want that to be correct.

QUESTION: How did you create your screen shots and assign them url's? What is process?

Hope this Helps

__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

Peace 95,

Here is what is in the book