Oracle Tag Directory

Featured Oracle Questions

Oracle RAC License on Oracle VM
Is it possible to purchase just one Oracle EE and RAC processor license for use with Oracle VM on a test server, or is there a minimum purchase of 2 processor licenses for EE and RAC? The test server has intel cores, which are a 0.5 factor license, therefore, 2 guest VMs would be created...

Answer Question   |  April 13, 2014  7:16 PM
Oracle VM
asked by:
5 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.

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.

undisclosed recipients
how do you create an undisclosed recipients

Answer Question   |  January 10, 2014  4:30 PM
Undefined Function
asked by:
5 pts.

export data from forms to excel
how to export the selected data from forms to excel?..

Answer Question   |  December 11, 2013  6:55 AM
PL/SQL, SQL
asked by:
5 pts.

PL/SQL – How to make a check whether the attribute is positive or zero
Hi Experts, How to make a check on attribute(NUMBER) is positive or zero?

Answer Question   |  November 27, 2013  4:55 AM
Oracle PL/SQL, PL/SQL, PL/SQL attributes, PL/SQL Variables
asked by:
610 pts.

CPU processor information on my virtual machine
I’m using a a C# code to find processor information. My Management “Processorld” is null if I run my application on a VM. I’m using Oracle VM VirtualBox for my virtual PC. Here’s the code I’m using: System.Management.ManagementClass Management = new System.Management.ManagementClass("Win32_Processor"); Has anyone experienced this problem before?

Answer Question   |  October 31, 2013  5:19 PM
Oracle VM, Virtual machine, VirtualBox
asked by:
54,655 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.

Oracle Forms 6i – “when timer expired”
I don’t know the logic of “When Timer Expired” trigger in forms 6i. Can someone please explain it (with examples)?

Answer Question   |  October 28, 2013  3:48 AM
Oracle 6i, Oracle Forms, Oracle Forms 6i, When Timer Expired Trigger
asked by:
40 pts.

How to uninstall Oracle Virtual Box
I got my VirtualBox totally screwed up, I removed the O/S (Windows 8 and Server 2008) and tried to start over. I didn’t install them properly, now when I try anew it says “this folder already exists and possibly belongs to another machine” now I can’t do anything so I thought I would uninstall VirtualBox...

Answer Question   |  October 28, 2013  11:48 AM
Oracle VM, VirtualBox
asked by:
15 pts.

How to run a stored procedure directly from a begin- end; statement?
I have a stored procedure with some dbms_output statements in it , i want to run this stored produre directly from begin end; statement in order to check how it woks…

Answer Question   |  October 25, 2013  8:08 PM
DBMS, Oracle, PL/SQL block, SQL
asked by:
500 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.

Undefined report
Why would an undefine report attached itself to the bottom of a report that is defined?

Answer Question   |  September 25, 2013  11:05 AM
Undefined Function
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.

Store image from a directory into Oracle database using SQL
I have a directory containing 1000s of photos which I have to upload into Oracle 9i DB. I need to use only SQL plus for this. I want a simple material to upload all those photos.

Answer Question   |  September 6, 2013  10:40 AM
Image databases, Oracle image storage, SQL, SQLPlus
asked by:
5 pts.

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 opening the Excel file but no data can be...

Answer Question   |  August 20, 2013  8:41 AM
excel, Oracle Forms, Oracle Forms 6i, PL/SQL
asked by:
5 pts.

Email attachment in APEX
I was successful in sending bulk emails from an Apex application I developed to an email account on my hMail server but when the email reaches the account, all fields are delivered except the attachment. Below are the PL/SQL codes. Please, kindly help me check it through. Thanks DECLARE TYPE t_rec IS TABLE OF USERS%ROWTYPE...

Answer Question   |  June 25, 2013  10:12 AM
hMail Server, Oracle Apex, PL/SQL
asked by:
70 pts.

Oracle Reports 6i style
Currently my report is being displayed in landscape style. I want it to be displayed by rotating it in a 90degree angle. For example, say my current report is ‘|’. I want to display it as ‘-’. The reason behind it was, the increase in the number of columns. Do we need to make any...

Answer Question   |  June 21, 2013  6:26 AM
Oracle Reports, Oracle Reports 6i, Oracle Reports Developer, Oracle Views
asked by:
15 pts.

Count distinct rows on multiple columns
I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00 Dollars 104 Sarah 010C...

Answer Question   |  April 19, 2013  8:23 PM
Access, Data/Application Integration, Database, DB2, Desktops, Development, Management, Microsoft Windows, Oracle, Oracle Business Applications, Oracle development, OS, PeopleSoft, Programming Languages, Security, Servers, SQL, SQL Server, T-SQL, Windows
asked by:
0 pts.

BULK COLLECT and FORALL in PL/SQL
How do I update multiple columns in a table using the BULK COLLECT… FORALL methods in PL/SQL.

Answer Question   |  April 19, 2013  3:11 AM
BULK COLLECT statement, FORALL statement, Oracle PL/SQL, PL/SQL
asked by:
20 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: