Free IT Book: The Data Warehouse Mentor
The Data Warehouse Mentor by Robert Laberge will show you how to plan, design, construct, and administer an integrated end-to-end DW/BI solution. He’ll explain how to choose appropriate components, build an enterprise data model, configure data marts and data warehouses, establish data flow, and mitigate risk. Change management, data governance, and security are also covered [...]

Answer Question   |  June 8, 2011  12:43 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

XML type in Oracle Form Developer 10g
hi, i am using oracle form devloper 10g, i have a xmltype column in a table(oracle database), i am not able to access value of that xmltype in oracle form developer 10g. how to acces can anyone suggest?

Answer Question   |  June 7, 2011  11:48 AM
Oracle Developer, Oracle Developer 10g, Oracle Forms, Oracle Forms 10g, XML, XML development

Empty reports in TMG2010
I am running Windows Server 2008 R2 Enterprise and Forefront TMG 2010 adn SQL-Express as local database After upgrading Forefront TMG 2010 to sp1 reports stopped generates. Reports are empty. First problem was “The report server cannot process the report. The data source connection…

Answer Question   |  June 6, 2011  5:15 AM
Forefront TMG 2010, Report Server, SQL Express, SQL Server Report Server, WAIK for Windows 7, Windows Server 2008 R2

Oracle Forms/Reports 10G/11G on Oracle Database 9i
Can I use Oracle Forms/Reports 10G/11G on Oracle Database 9i?

Answer Question   |  June 6, 2011  1:31 PM
Oracle Database, Oracle Forms, Oracle Reports, Oracle Reports 10g

Oracle (PL/SQL) fuction won’t work
I’m trying to run the following script: function create_new_password (p_email in varchar2) return varchar2 as l_password varchar2(12); l_encrypted_password varchar2(32); begin select dbms_random.string('A', 8) into l_password from dual; l_encrypted_password := password_hashing(p_username => upper(p_email), p_password => l_password); update customer set encrypted_password=l_encrypted_password where upper(customer.email)=upper(p_email); return l_password; end; and i’m getting the following error: Error at line 10: PL/SQL: [...]

Answer Question   |  June 6, 2011  8:53 PM
APEX, Oracle, Oracle Apex, PL/SQL

Oracle Package Script
Hello everyone…  I’m trying to create a package for an application on oracle APEX!! Here’s the code I used:  create or replace package customer_authentication as function customer_exists (p_email in varchar2) return boolean; procedure insert_new_customer ( p_fullname in varchar2, p_email in varchar2, p_password in varchar2); function customer_authentication_f ( p_username in varchar2 default null, p_password in varchar2 [...]

Answer Question   |  June 3, 2011  4:11 PM
Creating Oracle packages, Oracle, Oracle Application Express, Oracle Package

Free IT Book: Building Applications in the Cloud
This week’s free IT book, Building Applications in the Cloud: Concepts, Patterns, and Projects, is Christopher Moyer’s guide to help you not just migrate to the cloud, but “use cloud architectural patterns that deliver superior performance, scalability, and availability.” Whether you’re building a new cloud solution or adapting code that already exists, this is a [...]

Answer Question   |  June 2, 2011  1:35 PM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, Cloud computing books, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Running a query in Oracle 10g
How to rung query in oracle 10 g, if i run query it will be error coming, it will ask connection. can u tell me how connect databse file in sql developer which is install from oracle.com?

Answer Question   |  June 1, 2011  5:53 AM
Oracle 10g, Oracle Query, Oracle SQL Developer, SQL Developer

Error message through Email notification in Oracle Forms
How do i send error message through Email notification in Oracle Forms?

Answer Question   |  August 9, 2011  1:46 PM
Oracle error messages, Oracle errors, Oracle Forms

Oracle 6i parameter value
HI, Friends this is Nayeem, I need a help from your side. i have a report in oracle 6i, the problem is i have three parameter of date like WHERE ((MANT_REQ.REQ_DATE between R1 and R2)and (MANT_REQ.MANT_REQ_NO=: MAINE_REQUEST)) in this i have list of values for all three parameter my problem is when i m selecting the [...]

Answer Question   |  May 31, 2011  5:54 AM
D2K, D2K 6i, D2K Forms, Oracle 6i, Oracle Forms 6i

Numeric or Value Error for string aggregation
Hi, I use below code for string aggregation. My database table which I apply string aggregation is a large one with 165 million rows. Although I use CLOB, I get numeric or value error in eggregation termination function after the script is run for a long time. For a small table, I do not get [...]

Answer Question   |  May 27, 2011  1:57 PM
CLOB, CLOB Problem, String testing

Auditing Oracle 10g and above
Is it possible to fully audit Oracle Databases without Oracle’s audit tools? At least on 10g and above, many of the configuration files that could be reveiwed and audited for content and permissions no longer exist or are not used. Init.ora, sqlnet.ora are no longer used, and I suspect I will find others as I [...]

Answer Question   |  May 25, 2011  7:15 PM
Auditing, Oracle 10g, Oracle 10g administration, Oracle Database, Oracle Database 10g, Oracle security

Oracle fails due to disk partition is full. Data now is corrupted.
Hi all, I have a big trouble with one application that is working in a wrong way due to Oracle failure. Oracle is running on AIX. I just have access to see the disk partitions on the server with df command but I have no access to see Oracle logs. I can see that one [...]

Answer Question   |  May 26, 2011  5:06 PM
AIX, Corrupted database, Oracle, Oracle Database, Oracle database administration, Oracle error messages, Oracle errors

Can I use then Forms 6i DDE build-in package to generate 2010 EXCEL File?
Hi All, My company’ application is used Oracle FORMS 6i Solution,Client /Server environment to generated EXCEL file I coding the PL/SQL in the Oracle FORM , it’s succeed generated EXCEL file in MS office Excel 2007/2003/2000. Now I have problem in MS office Excel 2010 , It’s just open the Excel file but no data [...]

Answer Question   |  May 25, 2011  8:41 AM
excel, Oracle Forms, Oracle Forms 6i, PL/SQL

You Pick: Drupal’s Building Blocks, Scalability Rules, Building Cloud Apps, DTrace
This week, you get your pick of our most recent IT book titles. Check out our latest titles in the IT Bookworm Blog for more details on these books: Scalability Rules Multicore Application Programming Drupal’s Building Blocks Building Applications in the Cloud DTrace To win one of these great resources, answer a question from the [...]

Answer Question   |  May 25, 2011  5:22 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT answers, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

How can I use the application server in Oracle Developer 10g?
i am using oracle database 10g with oracle developer 10g and i want to use the appilcation server to run the form in different machine 

Answer Question   |  May 23, 2011  2:08 PM
Application servers, Oracle Database 10g, Oracle Developer 10g, Windows Application Server, Windows Server

Contest Bounty: Ask/Answer questions this weekend, earn 100 points!
Is the rain keeping your weekend plans from getting off the ground? Well, IT Knowledge Exchange has a chance for you to take advantage of staying indoors. Ask or answer 10 questions* this weekend, and you will earn 100 knowledge points, good for our current contest! Any combination of asking/answering is acceptable. Post the links [...]

Answer Question   |  May 20, 2011  3:50 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT answers, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Oracle Forms 6i application to web based application
how to develop my web based application from my existing forms6i

Answer Question   |  May 19, 2011  12:19 PM
Forms Creation, Oracle applications, Oracle Forms 6i, Web-base apps

Unicode on AS/400 RPGLE
We are upgrading to 9.0 JD Edwards where the unicode tables have CCSID = 13488; I still need them to work with legacy files, CCSID = 37. How can I get these 2 types of tables to interact within RPGLE (V6R1M0).

Answer Question   |  May 20, 2011  8:23 PM
AS/400, CCSID, JDE, RPGLE, Unicode

Free IT Book: Governing Shared Services On-Premise and in the Cloud
This week’s free IT book is from Prentice Hall: SOA Governance: Governing Shared Services On-Premise and in the Cloud. From the publishers: “[This book] is the result of a multi-year project to collect proven industry practices for establishing IT governance controls specific to the adoption of SOA and service-orientation….[It] steps the readers through the most [...]

Answer Question   |  November 30, 2011  4:04 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server