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
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
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.
Reply With Quote
  #2 (permalink)  
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.
Reply With Quote
  #3 (permalink)  
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.
Reply With Quote
  #4 (permalink)  
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.
Reply With Quote
Reply


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

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



All times are GMT -4. The time now is 10:29 AM.


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