Oracle Longops Queries.
Hi, Does anyone know the criteria based on which oracle defines a query/transaction to become a candidate for longoops.

Answer Question   |  January 18, 2006  2:34 PM
Database, DB2, Oracle, Windows

How to send mail from oracle forms
Hello I would like to send a mail from oracle forms, When i click submit button , a mail should be send to the user. How do i achieve this regards swapna

Answer Question   |  November 3, 2011  12:21 AM
Oracle

ORA-01000 error even if all statements and resultsets are closed in finally
I am getting ORA-01000 error even if I have closed all statements and resultsets in finally for all query (not using prepared statements). Also OPEN_CURSOR is set to 500. We are using Oracle 8.1.7 and in JDBC driver ‘Enable Resultset’ is ON and ‘Enable Closing cursors’ is OFF Please suggest how to solve is issue. [...]

Answer Question   |  December 29, 2005  11:22 PM
Database, DB2, Java, Oracle, Software, SQL, Tech support, Windows

Educating database users
Database administrators must always be prepared to handle users’ database problems and concerns — even if those users are quick to blame for every small thing that goes wrong and rarely praise when big things go right. It may be a lack of education; users just don’t understand the work involved with managing and maintaining [...]

Answer Question   |  January 11, 2006  12:00 AM
Data analysis, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server

64 bit Oracle
Hi, I’d like your opinion on migrating to 64 bit platforms. Right now our Oracle 9 databases are on Windows 2003 32 bit HP servers. We re running into memory and performance limitations and are thinking about moving to 64 bit. IBM’s Power servers are tempting, even with the added expense of learning Linux. Bit [...]

Answer Question   |  December 27, 2005  4:03 PM
Database, DB2, Oracle

Run exe from Forms 6i
Hi Can I run an external exe app from a when-button-pressed trigger? If the exe expects input parameters and outputs a code can these also be processed by forms 6i? If so, how do I acheive this? My OS is Windows 2000. Thanks.

Answer Question   |  December 27, 2005  12:51 PM
Oracle, SQL

difference between materialized views and tables
Hi, I got a question regarding the difference between materialized views and tables. As I know, materialized views will store the data with the view, so that next time while running sql against the materialized view, it will not do the query in view again. But is there any differences between materialized views and tables. [...]

Answer Question   |  February 17, 2012  7:50 PM
Oracle

Print Numbers in words
By using a single SQL Query Is it possible to print numbers in words. Example : To print “5,550 Dollars” in words Expected Query result : “Five Thousand Five Hundred and Fifty Dollars Only” Is it Posssible by a single query

Answer Question   |  December 29, 2005  10:11 PM
Career development, Certifications, CRM, Database, DataManagement, DB2, Desktops, Development, Functional, Lifecycle development, Management, Microsoft Windows, Oracle, OS, Performance/Load, Security, Servers, Software, Software Quality Assurance, Software testing tools, SQL, SQL Server, Tech support, Windows

Oracle HA Database Architecture on Linux
Are there any high availability database architectural issues/options to be conscious of on Linux?

Answer Question   |  December 13, 2005  5:16 PM
Database, DB2, Oracle

Old Approach App in XP
Hello, Have an older Lotus Approach ’97 DB App here that I have been asked to see what it would take to get back working in our XP enviroment. This is about 10 Approach Databases in an relational type of setup with about 2000 records and 150 or so custom layouts. Have messed with it [...]

Answer Question   |  January 4, 2006  10:08 AM
Database, DB2, Development, Oracle, SQL

Procedure Error
Hi Friends, would appreciate if someone could let me know the error in the Stored Procedure. It doesn’t compile successfully right now and feel there is a mismatch between the ‘Begin’ and ‘End’ keywords. Pl. confirm. Thank You, Friend33 Create or replace procedure proc_name IS Pwd varchar2(8); user varchar2(8); v_email varchar2(40); FUNCTION new_password RETURN VARCHAR [...]

Answer Question   |  December 8, 2005  9:22 AM
Database, DB2, Oracle

Outlook – creating Contact Lists under one main List
I’m using MS Outlook 2000 SP3 (9.0.0.6627). My company has about 1,000 customers/offices that we support. I’m working on a project and need to keep track of my contacts at each office. I first need to put all of the offices I contact into one large group. Each office is different. Some have one contact. [...]

Answer Question   |  December 12, 2005  9:12 AM
Automated, Call Centers, Career development, Certifications, CRM, Database, DB2, Development, E-business, Exchange, Exchange security, Oracle, Partner facing, Project management, Software, Software testing, Tech support, Training

Procedure Compilation
Hi Friends, Have a small glitch and hence hope you will spare me a moment. Have a small procedure and it is not compiling. Could you just have a look and let me know why ? Thank You, Friend33 PROCEDURE Create or replace procedure proc_name IS Pwd varchar2(8); user varchar2(8); v_email varchar2(40); BEGIN Create or [...]

Answer Question   |  December 7, 2005  4:58 AM
Database, DB2, Oracle

Method for capturing and storing long-running transactions real-time
We are running into a situation whereby we experience a build-up of long running transactions in the database, eventually bringing everything (including App servers with severe JVM spikes) to a halt. I’d like to find a way to capture long-running transactions real-time so as to alleviate the spikes before they get out of hand. Any [...]

Answer Question   |  December 9, 2005  3:00 PM
Oracle

iSeries any beyond
I’ll start by introducing myself and my background and then hopefully explain what information i’m looking for. I’m a COBOL developer for an insurance company based here in Ireland. I’d like to think of myself as been proficient at programming and at navigating my way around the AS/400. I have experience in other non-AS/400 languages, [...]

Answer Question   |  December 3, 2005  6:31 AM
AS/400, Data analysis, Database, DB2, Development, Oracle

How to solve lock problem in Oracle 9i on Linux
Hi DBAs I have foundPersistent Lock in my database Suggest me how to solve this error.

Answer Question   |  December 2, 2005  6:57 AM
Database, DB2, Oracle

Cannot connect to Database Oracle Error -1033.
Hello, I have a Problem with my HP B132L-Workstation, running HP-UX 10.20 and Oracle 7.x. An application, which is based on the Oracle database won’t start any more with the Error Message: Cannot connect to Database Oracle Error -1033. My first guess was, that the Harddisk is defective, or the Database is somehow corrupt. Against [...]

Answer Question   |  December 1, 2005  3:15 PM
Database, DB2, Hardware, Oracle, Software, Tech support

Remore RS232 Control
Good Day All I wondered if anyone knows how to remotely access and control RS23 devices. I will give you my example. I have a PC which is attached to 2 RS232 devices. I would like to have some form of control of the devices attached to the PC from a remote location, like a [...]

Answer Question   |  December 7, 2005  6:25 AM
Cabling, Database, DataCenter, DB2, Desktops, Development, DHCP, DNS, Exchange, Hardware, Management, Microsoft Office, Microsoft Windows, Mobile, Networking, Networking services, Oracle, OS, Project management, Security, Servers, Software, SQL, SQL Server, Tech support, Wireless

Regarding Oracle connectivity issues
I have Oracle 7i and 9i installed on my PC under C:/ORANT and C:/ORA9 respectively. When i try to connect to Oracle from a front end application (Visual Basic v6)that takes as input the Database domain name and Database schema name as input and tries to establish a connection to Oracle using the OLE DB [...]

Answer Question   |  November 29, 2005  7:51 PM
Database, DB2, Oracle, SQL, Windows

Date conversion (to_char) behavior
Hi everybody. We are experiencing a strange behavior with a “to_char” conversion: We are using Oracle 8i and Developer 6i. An application need to know the day of the week (number of day) of a given date, and we are doing that with “to_char(given_date,’D')”. This returns a 1 for sunday, and 7 for saturday, but [...]

Answer Question   |  December 15, 2010  2:01 PM
Oracle, SQL, Windows