Oracle Tag Directory

Featured Oracle Questions

How to uninstall OracleserviceXE
I am trying to install a new version of Oracle 10g. I thought that I had uninstalled the previous version but whatever I do I get the message “OracleServiceXE is present on the system”. How can I fix this please? Des

Answer Question   |  April 10, 2014  5:29 AM
Oracle 10g, Oracle error messages, Oracle installation, OracleServiceXE
asked by:
5 pts.

Why can’t I export and import in Oracle 10g database?
Export and Import are not supported on 10g databases for users logged in with the SYSDBA role. Logout and login using a different role before trying again.

Answer Question   |  April 4, 2014  9:56 AM
Oracle 10g, Oracle 10g Database
5 pts.

Getting ORA-29283 error when opening CSV file using UTL_FILE.FOPEN
I have a SQL script and all it does in to open a CSV file using UTL_FILE.FOPEN. I keep getting the ORA-29283 error.  I have an Oracle directory object pointing to the file location. Here is the code snippet: create or replace procedure “SKINNY” as v_inputfile             utl_file.file_type; v_filedata              varchar2(4000) := null; v_filename              varchar2(50) := null;...

Answer Question   |  April 1, 2014  12:24 PM
ORA-29283, Oracle 10g, SQL, Sql Script
asked by:
355 pts.

SQLERRM = ORA-06502: PL/SQL: numeric or value error: character string buffer too small
My procedure is shown below. When I execute it, it gives me the title error. Field3 is identified as a CLOB. Any / all help would be greatly appreciated. Running Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 CREATE OR REPLACE PROCEDURE xxx IS FileHandle SYS.UTL_FILE.FILE_TYPE; FileName VARCHAR2(2000); FileText VARCHAR2(2000); vField1 TABLE.field1%TYPE; vField2 TABLE.field2%TYPE; vField3 TABLE.field3%TYPE;...

Answer Question   |  March 26, 2014  3:07 PM
ORA-06502, PL/SQL, PL/SQL error messages, PL/SQL: numeric or value error
asked by:
Bw7
5 pts.

Looking for my Oracle 10g username and password
I need my Oracle 10g user name & password. Just now, I installed Oracle 10g software. Can anybody help me in this case?

Answer Question   |  March 26, 2014  4:59 AM
Oracle 10g, Oracle software
asked by:
5 pts.

Crystal Reports 8.5 Cannot insert Field or Text Objects
I have been using 8.5 for years without any problem. Recently I have been unable to create any new reports. I am not allowed to insert any field or text objects. I am also unable to modify any of the existing thousands of reports. I have reinstalled a number of times. It will work for...

Answer Question   |  March 12, 2014  9:13 PM
Crystal Reports 8.5, Crystal Reports error messages, Crystal Reports Errors, Oracle 10, Windows XP
asked by:
5 pts.

How to generate alerts via forms in Oracle 10g?
Hi all,    SELECT Count(1)    FROM regal.regal_inv_landed_cost_tab a    WHERE organization_id = 81    and not exists(SELECT a2.inventory_item_id  FROM mtl_system_items_kfv a2                                         where a1.inventory_item_id =a2.inventory_item_id                    ...

Answer Question   |  March 2, 2014  10:14 AM
Oracle 10g, Oracle coding, Oracle Forms
asked by:
20 pts.

How to import or add metadata in a microstrategy report?
How to import or add metadata in microstrategy report, and fact table , dimension table also.

Answer Question   |  March 1, 2014  10:42 AM
Computer science, Dimension table, Fact table, Microstrategy
asked by:
5 pts.

java.lang.NoClassDefFoundError
Hi, I need some serious help here..I use OAS 10.1.2.0.2.. I deployed my ear file to the OC4J container. And everytime I access the webpage I get this error. 500 Internal Server Error java.lang.ExceptionInInitializerError at com.experio.common.util.AppUtil.getInitialContext(AppUtil.java:71) at com.experio.common.util.AppUtil.createEJB(AppUtil.java:199) at com.experio.common.util.AppUtil.createEJB(AppUtil.java:156) at com.experio.common.util.Debug.println(Debug.java:64) at com.experio.web.control.Entry.service(Entry.java:67) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind[Oracle Application Server Containers for J2EE 10g (10.1.2.0.2)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:824)...

Answer Question   |  February 7, 2014  11:40 PM
Java development, JDeveloper, Oracle 10, Oracle Application Server, Oracle development, Oracle JDeveloper, Web development
asked by:
5 pts.

Hide ID and Password in web.show_document
How do I hide the id and password in a web.show_document command executed from an Oracle 10g form?

Answer Question   |  February 2, 2014  8:39 PM
Oracle 10g, Oracle 10g administration, Oracle 10g forms, Oracle Forms 10g, Web.Show_Document
asked by:
10 pts.

Error installing linux on Dell Poweredge 2950
I’m trying to install Novell Linux OS on a  Dell Poweredge 2950 server. 64-bit with raid and sas drives but i am getting a “no hard disk found” error

Answer Question   |  January 22, 2014  2:35 PM
Dell Poweredge 2950, Linux, Novell, OES
asked by:
56,090 pts.

convert report to excel without convater
Is it possible to convert a 10g generated report to excel without excel convater?  

Answer Question   |  December 5, 2013  9:13 AM
Microsoft Excel, Oracle 10g
asked by:
15 pts.

oracle 10g query
i need sum of income amount from income table and sum of expense amount from expense table to calculate the profit or loss. i have no idea how can i link these two tables.

Answer Question   |  November 10, 2013  8:31 AM
Oracle 10g, Oracle Query
asked by:
110 pts.

Oracle 10g express edition problem
Sir I’m using Oracle 10g express edition but when I try to open the homepage (start–>oracle database 10g express edition–>go to database homepage), it displays a message ” 127.0.0.1:8080/apex” unable to open. What should I do now?

Answer Question   |  November 10, 2013  8:05 AM
Oracle, Oracle 10g, Oracle 10g error messages
asked by:
5 pts.

how to run proc in Oracle 10g
I have oracle 10G (GUI based-running in IE) .how do i compile and run proc code in it

Answer Question   |  November 10, 2013  9:03 PM
Oracle 10g
asked by:
56,090 pts.

Oracle 10g – WEB.SHOW_DOCUMENT parameters
What other parameters can be used with WEB.SHOW_DOCUMENT besides ‘_BLANK’?

Answer Question   |  October 28, 2013  9:23 PM
Oracle 10g, Oracle default parameters, Oracle Forms, Oracle Forms 10g, Web.Show_Document
asked by:
355 pts.

What are the technical capabilities for Parrot versus other VMs?
This is more of a general question: I know Parrot is the virtual machine that was originally designed for Perl 6. I’m actually trying to figure out what the technical capabilities Parrot”s VM offers against other competing VMs (Java Virtual Machine/Common Language Runtime)? Thanks!

Answer Question   |  October 25, 2013  8:11 PM
CLR, JVM, Parrot, Virtual machine
asked by:
56,090 pts.

Link Oracle 10g with SQL Server problem
I have created a link between our Oracle DB and SQL server db It was successfully created and I was able to select data from oracle table using SQL Server. Then I have created a view in SQL Server using this link to read from Oracle, the view was created: create view dah_test as (...

Answer Question   |  October 23, 2013  8:00 AM
Error 7399, Oracle 10g, Oracle error messages, OraOLEDB.Oracle, SQL Server errors
asked by:
35 pts.

ORA-01722 invalid number where clause in update statement. I want to log this error in error log table
Oracle ora-01722 invalid number where clause in update statement. I want to log this error in error log table. How can i log?? Below is my Update statement, here empid is number. UPDATE SARVESH_TEST_ERR_TB SET empid = empid WHERE empid =’aaa’ LOG ERRORS INTO SARVESH_ERR_LOGS_TB (‘Error while UPDATE’) REJECT LIMIT UNLIMITED; If we gibe set...

Answer Question   |  October 23, 2013  4:59 AM
ORA, Oracle 10g
asked by:
5 pts.

Call parameter from Oracle Reports 10g web.show_doc
Here’s the code: DECLARE rep_url varchar2(2000); BEGIN rep_url:='/reports/rwservlet?' ||'&report=c:testrpt10g.rdf' ||'&desformat=htmlcss&destype=cache' ||'&userid=stlexport/stlexpst@as'; WEB.SHOW_DOCUMENT(rep_url,'_blank'); END; It’s running well but now I want the report’s parameter form to be displayed. How can I do this using web.show_document(…)

Answer Question   |  September 11, 2013  9:20 AM
Oracle 10g, Oracle development, Oracle Forms 10g, Web.Show_Document
asked by:
35 pts.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: