Wrox Programmer Forums
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 26th, 2009, 08:12 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 No Data Found

This is the third time I have entered this new thread, the review post button is taking me to the login screen......

I am in Chapter 4 page 93 testing the Date-Stamp Valiation and I get the following error message,before the order item page:
Code:
Invalid PL/SQL expression condition: ORA-06550: line 1, column 34: PLS-00103: Encountered the symbol "," when expecting one of the following: ( ) - + case mod new not null <A double-quoted delimited-identifier>table continue avg count current exists max min prior sql stddev sum variance execute multiset the both leading trailing forall merge year month day hour minute second timezone_hour timezone_minute timezone_region timezone_abbr time timestamp interval date
Listing data from the executing page via App Builder from the traffic-light icon, all the Orders are listed. However listing the orders table via the Utility browser via SQL Workshop, I receive the message "No data found".

Do I need to start over from scratch?
__________________
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.
 
Old April 30th, 2009, 02:50 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
Thumbs up

Problem: Resolved.

This was not a "user error", but a problem with the Oracle Database. I am using the free hosted APEX Account.

The Beginning Oracle Application Express is one of the better books for anyone who would like to make the transition into Web-base Application Development and not just introducing the Oracle World. You really learn by building the Order-Entry System using APEX.
__________________
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.
 
Old May 10th, 2009, 03:06 PM
Registered User
 
Join Date: May 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Could you share a little more information?

Quote:
Originally Posted by peace95 View Post
Problem: Resolved.

This was not a "user error", but a problem with the Oracle Database. I am using the free hosted APEX Account.

The Beginning Oracle Application Express is one of the better books for anyone who would like to make the transition into Web-base Application Development and not just introducing the Oracle World. You really learn by building the Order-Entry System using APEX.
Thanks for the kind words about the book - please feel free to post on Amazon

Could you share a little more details about the problem with the Oracle database with your hosted account? This is something which could be useful to others working with the book.

And thanks again.
 
Old June 23rd, 2009, 06:00 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 No Data Found....

OracleDB Problem:
After receiving what I thought was a syntax problem, Iwent back to the Application page and ran the previous page....the page generated the correct data, which I realized later it was cache data. So I went to the object browser to view the data, I received the error message No Data Found...After clicking on all the tables and receiving the same error message. I decided to look at the Application that I had started when I first received my host account. Clicking on that Application, I received a security error message which stated, that I did not have the rights to access the account.... That is when I emailed the Oracle Apex Support Group, thinking my account was locked.

The response to my email was that they were aware of the problem and that it should be fixed by now. It was an Oracle Database problem. I was glad that everything was back to normal....I did not want to start over a third time...
__________________
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.




Similar Threads
Thread Thread Starter Forum Replies Last Post
NO DATA FOUND nkrust Oracle 1 February 15th, 2007 07:55 AM
Method or data member not found Subuana Beginning VB 6 1 March 6th, 2006 03:32 PM
Method or Data member not found Anup Gavate VB How-To 2 March 25th, 2005 04:50 PM
err 2580 - data source not found DavidCC SQL Server 2000 4 April 1st, 2004 03:19 PM
Error: Data source name not found and no default d Justine Classic ASP Professional 1 January 23rd, 2004 11:34 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.