Problem solve
Get help with specific problems with your technologies, process and projects.
Oracle Java and J2EE
Unable to view Oracle tables in NetBeans
I am very new to databases (Oracle 9.2 installed) and my problem is I'm not able to view tables in NetBeans 5.5 even after establishing the connection with the database via NetBeans. Continue Reading
Can I make a second connection to Oracle without losing the first?
Is it possible to have a stored procedure make a second connection to Oracle without losing where you're at in the first connection? Continue Reading
Impact of Oracle 9i upgrade on Java front end
I am using Java as the front end, so what is the impact of the upgrade? Do I need to upgrade Java versions or ODBC Drivers? Continue Reading
-
Why isn't Oracle user-friendly?
Working with SQL Server is simple. Oracle is an enterprise database and powerful but why has it never been user-friendly? Continue Reading
Web Services 101 for DBAs and data architects
Web services promise simplified interfaces for application-to-application interaction. This chapter describes the key technologies that enable them (such as XML, WSDL, SOAP and UDDI) and then peeks at the bigger picture of service-oriented ... Continue Reading
ORA-00904 error on select statement
I am working in JDEVELOPER using JDBC. This program is working with objects. I am getting this error on a SQL statement: "java.sql.SQLException: ORA-00904: "R": invalid identifier." How do I fix this? It seems like object r is not connected to ...Continue Reading
What other certifications will increase my market value?
I am an Oracle certified DBA, with work experience of more than four years. I want to do some other certifications so that I can increase my market value.Continue Reading
Better performance with varchar2(1) or number(1)?
Since Oracle table structures do not support a boolean datatype, I am faced with a choice (make it a varchar2(1) or number(1)), with contents of Y,N or 1,0. Which provides better performance?Continue Reading
Developing a performance monitoring tool
I want to develop a performance monitoring tool for Oracle. What are the important parameters I should consider? This tool must be independent of any platform. Which language would you suggest to use?Continue Reading
ORA-12571 error with Oracle 8i on Windows XP
I am getting "ORA-12571: TNS:Packet writer failure" when I write tnsping [sid name] in the DOS prompt. I have installed Oracle 8i Enterprise on Win XP. I am able to create the database but unable to connect with Java using Oracle thin ...Continue Reading
-
Problems transferring Oracle data after upgrade to XP
I am using Oracle E-Business Suite version 11i. Ever since my computer was recently upgraded to Windows XP, I have not been able to transfer any data between Oracle screens using copy and paste, and Oracle screens will not print. When I was in NT, ...Continue Reading
Generating XML from stored procedures
What are the best ways to generate XML from stored procedures? I have tried using SQLX with version 9i and it works pretty nice. I would like to know if you can recommend any other ways of doing it and suggest which approach has to be taken in what ...Continue Reading
Rolling back Oracle XSU
Some of the Oracle XSU that I create contains several inserts/updates and I would like the opportunity to rollback if just one of those inserts/updates fails but this seems impossible as I only get the aforementioned int and not Exceptions thrown ...Continue Reading
Using Java for Web-deployed Forms
This tip explains why Java is a compelling solution when working with Web-deployed Forms, and how to work with pluggable Java components and Java methods.Continue Reading
Coding stored procedures in Java