Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Database > BOOK: Beginning Oracle Application Express ISBN: 9780470388372
Password Reminder
Register
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 Search this Thread Display Modes
  #1 (permalink)  
Old September 20th, 2010, 05:12 AM
Registered User
 
Join Date: Sep 2010
Location: Belgium
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Question Problem with "Rich User Interfaces" (BLOB intergration) in Chapter 6

I recently started reading this book and up till now didn't face any real problems. That is until I reached the "Rich User Interfaces" part in Chapter 6 (page 202).

Let me start by saying that I'm rather new to APEX (hence the reason I'm reading this book ;) ) and that I'm running APEX version 4.0.1.00.03 on an Oracle XE database. So yes, I realize this does not fully correspond with the 3.2 version this book was written for. But still, I imagine it shouldn't make that much difference. It's sometimes a bit annoying as the layout slightly changed, but nothing insurmountable.

However, I'm having problems creating the Form on a Table with Report option. When I follow the steps as described in the book (which correspond with another tutorial I found on the Oracle website), I can select the BLOB field in both the form and report, but after creating the pages, the image column is not present in the report page. While it's present in the form page, it doesn't seem to have any impact on the underlying table when adding an image. I manually changed the source select for the report page and added the image field. When I run the report, I don't get the page as shown on page 205, where the value for the product image is a "-". In my case it says [unsupported data type]. When I follow the steps described on page 207 and change the Format Mask I get an error "ORA-06502: PL/SQL: numeric or value error: character to. So, I've to admit I kinda ran out of ideas.

Any suggestions would be more than welcome!

Thanks,

Erwin
  #2 (permalink)  
Old September 23rd, 2010, 01:42 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 Problem with "Rich User Interfaces" (BLOB intergration) in Chapter 6

Erwin:
I am nfamiliar with Oracle XE, however I do suggest that you try looking up how XE reads and displays images. Then take the information and convert one of the images to that particular format. Then use the image in the database and see how that works for you.

Keep me posted. Good luck!

peace95
__________________
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 September 24th, 2010, 02:37 AM
Registered User
 
Join Date: Sep 2010
Location: Belgium
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

peace95,

Thanks for your reply.

In response to your reply. Oracle XE (or Express Edition) basically is a full working Oracle 10.2.0.4 Standard Edition, with some limitations (see the following page for more information: http://www.oracle.com/technetwork/da...iew/index.html ). This is Oracle's answer to free and opensource databases, which have become more popular over recent years (in part due to Oracle's high licensing costs. The same goes for MS SQLServer and DB2 BTW). I personally think it's the perfect solution for test environments, but also for relatively small production environments. Contrary to what some people believe, Oracle XE is a robust production database which has most of the features of it's big Standard Edition brother (not talking about EE of course).

So basically, what works in Oracle 10g, also works in XE. This means that BLOB's (as well as other Oracle datatypes) are fully supported and can be used to store images. I don't think the problem is on the database side. I don't seem to have any problems with BLOB's on the database side and can edit them without problems in a tool such as TOAD.

Maybe later, if I have some time, I'll run a test on a 10g database (don't really have a 11g database up and running at this time).
  #4 (permalink)  
Old December 19th, 2010, 11:18 AM
Registered User
 
Join Date: Dec 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Wink Problem with "Rich User Interfaces" (BLOB intergration) in Chapter 6

Erwin,

Change Report Definition to:
select "PRODUCT_ID",
"PRODUCT_NAME",
"PRODUCT_DESCRIPTION",
"PRODUCT_AVAIL",
"LIST_PRICE",
"CATEGORY_ID",
dbms_lob.getlength("PRODUCT_IMAGE") as "PRODUCT_IMAGE"
from "#OWNER#"."PRODUCTS"

Then continue with section 'Adding Image Display to a Report' in Chapter 6.

LowBat
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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
Problem: Chapter 7 "Saving Your To-Do List" (Page 218) DrGaribaldi BOOK: Professional Android 2 Application Development 2 March 21st, 2011 01:53 AM
Problem: Chapter 8 "Mapping Earthquakes Example" (Page 282) DrGaribaldi BOOK: Professional Android 2 Application Development 3 July 29th, 2010 06:24 PM
Problem: Chapter 7 "Creating and Using an Earthquake Content Provider" (Page 232) DrGaribaldi BOOK: Professional Android 2 Application Development 0 June 17th, 2010 04:07 AM
Chapter 18: Getting "Failed to generate a user instance of SQL Server" error HungryCaterpillar BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 5 November 11th, 2009 01:56 PM
Add a CheckBox DataColumn to my DataGridView, Null format: "" or "True" but Error: F ismailc C# 2005 0 September 25th, 2009 04:56 AM



All times are GMT -4. The time now is 01:56 AM.


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