We have recently done a server migration. When we try to print a specific report, not all reports. We get the error message:
ORA-12705: invalid or unknown NLS parameter value specified
A...
I have oracle 9.2.0.7 running on Windows 2003 Server with 4Gb RAM.
Random I recive the error
ORA-12547: TNS:lost contact
This appears when the backup run (yesterday all run fine todaz afte...
I am having a problem adding a database to a tree in Oracle 9i.
Ive done a considerable amount of surfing, and most solutions suggest editing TNS, Listener, and SQLNet files, but no dice. I ...
Hi I need to execute a stored procedure within an Oracle database using a SQL Statement. The reason for this is that I am haveng to extract data from a SQL system then write it to a file. I t...
Hi Guru
I have a fresh install of Oracle Client 9.2 and Oracle Database 9.2 on my Windows XP SP2 machine.
My machine is called LAXP001, the Net Service Name is DEVL, the Database is DEVDB, ...
Hi,
I have the following PL/SQL Code which sends an email correctly, but what i want to add an attachment (file.txt or file.xls).
Can anyone please tell me how to add an attachment to this...
I have a package and I would like to run it twice a day in the oracle database .
How would I schedule it ?
thanks,GYANS.
I have an ORACLE query for tuning which is taking a lot of time in the server. I have tried various hints like INDEX, USE_NL, ORDERED etc. but that wouldn't prove to be benificial.Can anyboy ...
Hello,
I have a simple query being spooled out through sqlplus in a pipe delimited format. The output looks good to the naked eye but I'm delivering it to a windows server for loading into s...
Hi,
i tried to use a stored procedure,for truncating tables.
but it throws exceptions
-----------------------------------------------------------------------------
4/10 PLS-00103: En...
I have defined a variable which is TABLE TYPE of variable. This variable holds all of results which is of course like a table. Now I want to write store procedue to pull out the results from t...
Hi,
just few days back we have done a installation of Oracle 9i on Solaris server. we also have our Weblogic and application running on the same server. Server has 2 CPU with 2 GB of RAM.
...
"ORA-29275 partial multibyte character. Cause: The requested read operation could not complete because a partial multibyte character was found at the end of the input.
Action: Ensure that the...
Six months ago TSM was setup and installed and RMAN setup to backup database by consultant. Recently been attempting to learn more about how it all works and to ensure that the backups were ac...
Dear all,
I have to do some PL/SQL coding and i cant say i excel to it, even tho i am eager to learn i am stuck while trying to concatenate multiple rows to one and then export them as a ne...
Dear experts
I want to tune my process wich use sqlldr , I want to upload average 120 millions rows dailly in database 9.0.1.0 on table IOT with partition per day
1/
CREATE TABLE DBM_MSC...
I need an example of how to open HTML file in oracle form 6i.
The requirements:
- prompt user to open Windows Explore (GET_FILE_NAME('\\c:\documents',File_Filter=> 'All Files (*.*)|*.HTML|'...
Hai !
i want to clear all the entries from user_jobs.
how to do this. ?
Hello,
one of our Oracle USERID's has the role "BECOME USER". I saw in different documentations, that this role is allowing to become another users, themselve sys.
ENVIRONMENT: Oracle 9i, ...
Hi,
I am working with oracle forms, which call the package in the database, the database package has procedures which edits or enter the data into a temporary table based on the parameters pa...
Iam trying to connect Netbeans 6 with my oracle 9i DB,
I have already add the driver classes12.zip from services -> databases -> Drivers.
Also I have already add oracle.jar by making new...
We currently backup our oracle database multiple times through out the day using the standard exp/imp utility in Oracle. This process works fine, but our database has been slowly increasing i...
SQL> select distinct object_type from user_objects;
OBJECT_TYPE
------------------
DATABASE LINK
FUNCTION
INDEX
PACKAGE
PACKAGE BODY
PROCEDURE
SEQUENCE
TABLE
TRIGGER
VIEW
desc...
Hi,
I created a report with delimiteddata (ORACLE forms and reports and iAS 9i), the report is showed on the preview screen very well, however I found that if I add to the report URL the fo...
hello...
We are running oracle DB 9.0.2 and oracle developer 6i rel2 for the application we have developed on client/server based tecnology..
the listener status is blocked once i go to the ...
