Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning Oracle Application Express ISBN: 9780470388372
This is the forum to discuss the Wrox book Beginning Oracle Application Express by Rick Greenwald; ISBN: 9780470388372
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Oracle Application Express ISBN: 9780470388372 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old July 4th, 2009, 10:49 AM
Authorized User
 
Join Date: Jul 2009
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default APEX 3.2

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.
  #2 (permalink)  
Old July 5th, 2009, 12:24 PM
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default

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.
  #3 (permalink)  
Old July 6th, 2009, 03:58 AM
Authorized User
 
Join Date: Jul 2009
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default

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"

Quote:
Question: Are Oracle 10g Express 2.1 and Oracle 10g APEX 3.2 on the same machine?
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
  #4 (permalink)  
Old July 6th, 2009, 08:37 AM
Authorized User
 
Join Date: Jul 2009
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default

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 : 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 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
  #5 (permalink)  
Old July 6th, 2009, 06:46 PM
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default

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.
  #6 (permalink)  
Old July 7th, 2009, 10:28 AM
Authorized User
 
Join Date: Jul 2009
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default

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.
  #7 (permalink)  
Old July 7th, 2009, 10:36 AM
Authorized User
 
Join Date: Jul 2009
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default

Checking if post working
  #8 (permalink)  
Old July 7th, 2009, 10:58 AM
Authorized User
 
Join Date: Jul 2009
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default

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

Quote:
Jawad,

The problem is that your application parsing schema is set up to be SYSTEM. We don't allow that any longer. You should consider creating a new workspace and have it use an ordinary schema, one where you want your objects to reside. Use the apex_admin interface to log in as the apex site administrator and use the Manage Workspaces > Create Workspace link.

Scott
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
  #9 (permalink)  
Old July 8th, 2009, 05:46 AM
Friend of Wrox
Points: 793, Level: 10
Points: 793, Level: 10 Points: 793, Level: 10 Points: 793, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2005
Location: OKC, OK, USA.
Posts: 227
Thanks: 1
Thanked 7 Times in 7 Posts
Default

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.
  #10 (permalink)  
Old July 8th, 2009, 08:11 AM
Authorized User
 
Join Date: Jul 2009
Posts: 14
Thanks: 0
Thanked 1 Time in 1 Post
Default

Peace 95,

Here is what is in the book

Quote:
"What This BookC overs
This book covers the use of Oracle Application Express. Although the book is based on the 3.5 version,you can use the book with older versions as well. However, since the book will use a hosted version of Oracle Application Express, and since both the Oracle Database that supports the product and the product itself are available as free downloads from http://otn.oracle.com, you should be able to use the latest version easily."
But the latest version is 3.2 and not 3.5, I think it is a typing mistake. Also heard APEX 4 is coming out.

Quote:
QUESTION: How did you create your screen shots and assign them url's? What is process?
1 - go to web site http://www.tinypic.com/
2 - Register and upload images
3 - Copy the Image URL links to any forums

Finally did it. Created a new workspace and it works like a charm. What needs to be done is

1 - Install Oracle Database 10g Express Edition (XE) (I think release 2) (10.2) whih comes with APEX 2.1 by default.

2 - Upgrade by Installing APEX 3.2

3 - For The Datbase the home page is
http://127.0.0.1:8080/apex OR http://localhost:8080/apex

4 - And for APEX the home page is
http://127.0.0.1:8080/apex_apex_admin OR http://localhost:8080/apex_apex_admin

There are underscore(_) between the apex and apex_admin AS apex_apex_admin

3 - Going to the Apex_admin home page and log in as the ADMIN and give the password. It will ask you to change the password. Once done, create a new workspace, schema and user and it works

Just in case any body else is facing the same troubles and wants to know.

QUESTION : Lets say I want to develop a fully functionally Database for a company with 20 to 50 users who are on an Intranet running windows XP professional SP3 for ORDERS booking and INVOICE raising. Now I have done all the background study for Database Modeling and Design including set theory and logic, ERD and its notations and all others. Using oracle 10g databse express edition and APEX 3.2 will i be able to produce a fully functionally databse application (backend + fronend) and install/deploy there.

Regards

Jawad
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off



All times are GMT -4. The time now is 07:12 AM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.