Notes.notessession custom sender
Hi, I’m using Oracle 9i, Developer 6i and Lotus Notes to send an email. I need to change the sender for another and I don’t know how to do it. Please, help me.

Answer Question   |  May 14, 2013  6:46 PM
Lotus Notes, Oracle 9i, Oracle Developer

Execution of Oracle 11g wrapped procedure gives ora-00900 error
Hi, I have a procedure which I wrapped using the oracle 11g wrap utility. If I execute the wrapped procedure using JDBC I am getting an error of 0RA-00900 invalid SQL statement. The procedure is having basic SQL statements only. The same procedure if i wrap using Oracle 9i and execute using JDBC it works [...]

Answer Question   |  April 5, 2013  4:29 AM
Oracle 11g, Oracle 9i

Stop Oracle database using by other application
I have Oracle 9i database & want to stop other people from using it and use other applications like SQL Developer & Toad.

Answer Question   |  March 11, 2013  9:37 AM
Oracle 9i, Oracle 9i database

How to install Oracle 9i on Win 2008 server?
error :- jrew.exe has stopped working so database not generated

Answer Question   |  January 21, 2013  12:18 PM
Oracle 9i, Windows Server 2008

Oracle 9i data dictionary definition & informational SQL queries?
I am using Oracle 9i on a specific application that was designed back in 2000 — no supporting documentation, very little training and I’m new to Oracle and sql. I’m currently using Toad for Oracle which allows me to create query templates. Toad for Oracle has existing sql templates which I can modfiy so I’m [...]

Answer Question   |  January 11, 2013  8:10 AM
Oracle 9i, Oracle 9i query

FRM-40403 A CALLING FORM HAS UNAPPLIED CHANGES SAVE NOT ALLOWED
Dear Friends I have order data entry screen form when the order item is not yet defined then I am using this script for calling the item definition form DECLARE l_n_curr_rec NUMBER; BEGIN BEGIN :global.l_n_curr_rec2 := :COP_ORDER_DETAILS.LINE_NO; :GLOBAL.CLASS_CODE := :CLASS_CODE; :GLOBAL.LINE_NO := :LINE_NO; :GLOBAL.USER_ID := ’1′; END; :global.cop_order_code := :cop_order_details.cop_order_code; :global.ord_date := :cop_order_details.ord_date; :global.command_line := [...]

Answer Question   |  November 4, 2011  5:13 AM
Oracle 9i

Oracle report 6i, report has 2 parameters and runs fine independently but i run this report from a form with parameters; reports ignore the parametrs
Report runs fine separately but when i call from a form and pass on required paramets, it does not show anything;

Answer Question   |  March 31, 2012  4:26 AM
Oracle 9i, Oracle 9i export parameters, Oracle default parameters

jrew.exe has stopped working while installing oracle 9i in windows 7 ulitemate
jrew.exe has stopped working while installing oracle 9i in windows 7 ulitemate

Answer Question   |  June 11, 2012  12:20 AM
Oracle 9i, Windows 7 installation, Windows 7 Ultimate

ORA106500:WHEN-BUTTON-PRESSED raised unhandled exception. … i want to open ms word file when button pressed trigger
Dear All i am using oracle 6i and oracle 9i database i want to open word file when pressed button in form but there is no error during compilation error at runtime showing below code wrote in WNBP trigger: declare AppID PLS_INTEGER; begin AppID := DDE.App_Begin(‘C:ProgramDataMicrosoftwindowsstart menuprogramsWINWORD.exe C:orantBINifbld60.EXEsupppe_pre2.fmb ‘,DDE.APP_MODE_NORMAL); end; plz if anyone help me

Answer Question   |  August 2, 2011  5:57 AM
Oracle 6i, Oracle 9i, Oracle developers, Windows 7

Oracle 9i eating up storage
i am using winxp sp3. i had installed oracle 9i server. it was installed succesfully before it takes only 2.8gb space. But now it is occuping all left space in c drive. as 15gb was free in c drive , now it takes 16gb space and when i uninstall any software the space made by [...]

Answer Question   |  March 24, 2011  10:12 AM
Oracle 9i, Oracle 9i Configuration, Oracle 9i installation, Storage, Windows XP SP3

Strange Oracle 9i behaviour
We are seeing some very strange behaviour in the performance of a query on our database. We have run the same query on the actual database server (s1) using sql+, and on a server (s2) 1 hop away (taking out network performance). The exact same queries, without any bind variables, are kicked off at exactly the same time. The [...]

Answer Question   |  March 28, 2011  1:43 PM
Oracle 9i, Oracle 9i performance, Oracle performance, Solaris 10, SQL Plus

Execution of Oracle 9i Developer Suite compiled form (fmx) ?
How to execute 9i DS compile form (fmx) from my PC desktop?

Answer Question   |  February 3, 2011  1:23 PM
Oracle, Oracle 9i, Oracle Developer Suite, Oracle Forms

Oracle 9i error message in Windows 7: jrew.exe
while installing oracle9i in laptop i a getting message jrew.exe stopping program(i am using windows 7)

Answer Question   |  September 23, 2011  12:37 AM
Oracle 9i, Oracle 9i error messages, Oracle error messages, Windows 7

Replicating Oracle 10g database in Oracle 9i
I have an oracle 10g database and would like to create a replica of it in oracle 9i. Could you please explaim if this is possible. I’m sure there would be backward compatibility issues to contend with.   Regards,

Answer Question   |  January 6, 2011  6:00 AM
Oracle 10g, Oracle 10g Database, Oracle 9i, Oracle Database, Oracle Database Versions

Problems installing Oracle 9i in Windows Vista
why their is a problem in installing the oracle 9i in windows vista?

Answer Question   |  December 23, 2010  1:43 PM
Oracle 9i, Oracle 9i installation, Oracle 9i installation errors, Oracle installation, Windows Vista

Crystal Reports 8.5 and Oracle 9i
Hi Brothers and lovers,          I’ve tried in designing the crystal report.while designing,i used multiple columns to view the records.Here i’ve a problem in designing.the problem is , i selected the down the across in the layout of details section in the crystal report 8.5.Through this i can’t control the record to next column before [...]

Answer Question   |  December 11, 2010  3:59 PM
Crystal Reports, Crystal Reports 8.5, Oracle 9i

What are the pitfalls of moving old windows server to a new location in the computer room?
what are the pitfalls of moving old windows server to a new location in the computer room?

Answer Question   |  December 9, 2010  8:51 PM
Data center relocation, Hardware relocation, Oracle 9i, Windows Server, Windows Server Migrations and Upgrades

Rename username in Oracle 10g database
Rename username in oracle 10g database without droping it

Answer Question   |  November 24, 2010  12:31 PM
Oracle 10g, Oracle 10g Database, Oracle 9i, Oracle administration, Oracle User Profiles

ORA-1555 insert table with 3 billions rows in Oracle with SQL
I have a big table with 3 billions rows and would like to rebuild in a less period of time as possible. I ran 3 plsql scrits , each plsql script is doing a full table scan to get 3 diferente range of data and insert in a new table , the commit in the [...]

Answer Question   |  November 18, 2010  6:05 PM
ORA-1555, Oracle 9i, Oracle Tables, SQL

Terminate SQL exception, if it is running more than a specified time.
Whether we can forcefully terminate an sql statement during its execution if it is running for a long time or running more than a specified time?

Answer Question   |  November 15, 2010  10:03 AM
Oracle 9i, Oracle performance, Oracle SQL, SQL Exception, SQL statement