Hi , If some has good doc which explain in detail about this AURORA$SERVER$SHUTDOWN trigger please share with me If have searh in the metalink but not getting...
I am using Oracle 9i DS on XP with Oracle 9i DB on Unix. I have a form and am trying to run a report from the form. This is what I have coded: repid =...
you can do it with run_product () also.I think that will sove ur problem. mmmangal@... wrote: I am using Oracle 9i DS on XP with Oracle 9i DB on Unix. I...
Hai Iam getting an error FRM-40815 when am running the form to generate a report on my local server which is on Win 200 OS where as my web server is on Unix ...
Dear Team Members, In one of our operating offices the Oracle 8.1.7 version is running, while in rest of our offices we always use Oracle 8.1.5. Now the...
Ayesha I am sanjay acharya from ahmedabad . My suggestion is set complitibility parameter in initR.ora file of the 8.1.7 which would be comptibility=8.1.5. and...
Hi All, I would like to know any of you implemented java stored procedure sending out TIBCO message. Please email me if you have implemented it Thanks, ...
Varughese M
varughesem@...
Sep 1, 2004 8:52 pm
435
HI ALL, Thanks for the responses, but i have got the solution. It is possible to downgrade the data of 8.1.7 to 8.1.5 by using d080105.sql and several other...
hi Ayesha Could u please tell the detail script of d080105.sql and the other scripts u used for downgrading the data of 8.1.7 to 8.1.5. i will be very thankful...
I create one trigger when i am trying to compile it is giving PLS-00417: unable to resolve "RTN_ORD_RTN_RSV_QTY" as a column while this column exist in table...
I'm implementing an application but I have to make a decision on use stored procedures or prepared statemnts. Do you have any experience and what will be your...
dear user Stored procedure is more useful if you want it in a very frequenlty used module as it stores all module in library cache once loaded in complile form...
The Fall Conference of the Northern California Oracle Users Group will be held on Thursday, November 4, 2004 at Computer History Museum in Mounta View. This...
Hi, my name is dayananda shenoy, i am working as an vb/oracle developer. currently we are developing a large scale centralised banking software in vb and...
Hi Dayananda, There are hints , which you can use to run part of the sql on remote site , decreasing cpu utilization on your local database & split the load. ...
Rajesh Arora
arora_rajesh@...
Nov 11, 2004 11:11 pm
443
Hi, Following Outerjoin Query, when used RULE based, gives exact result, when COST base is used giving Inconsistant result. SQL> desc IACLINK Name Type...
Hi It's my first connection to your Site. I'm a new user of Oracle and I must realize my End-Study project as soon as possible. I have install (on Windows 2000...
any solution please? ... soon as possible. ... Entreprise Edition release 8.1.7.0.0, then I have install Oracle Entreprise Manager release 2.1 with oracle...
I agree with Rajesh Arora if you can use hints that will be good enough. Also, if you can effort you can make a table in your local database, so that the...
Hi How to check the Database patch( using opatch or oui) whether it is applied or not. with regards Subrahmanyeswara Rao ... Do you Yahoo!? Dress up your...
p k s subrahmanyeswar...
bpkssrao@...
Dec 23, 2004 4:54 am
448
To check O/S Patches: HP $ /usr/sbin/swlist -l patch Linux $ rpm -qa Solaris 64-bit $ showrev -p For Database Patches: $ cd $ORACLE_HOME/bin $ owhat oracle ......
Here's the a way to do that : Importing to Access from Oracle Open Access => Blank Database => Save it => File => Get External Data => Import => Choose ODBC...
Hi Everybody, After checking lots of mail between the war of Committed Vs. Non-committed and Rollback Segment and Datafile. Could anybody give me a clear and...
All , Have gone thru several docs on how to avoid snapshot too old error in 9i while using automatic undo management . basically we need to set proper value of...
I would first go about finding out whats the longest query time in the db using v$undostat.maxquerylen . Based on that, set the undo_retention. Then also ...
Sudheendra Vijaykumar
sudhi76@...
Jan 18, 2005 1:27 pm
454
hi, currently i am working on a project where we are going to do bulk batch processings. for this we are using bulk collect and bulk insert features of oracle...
Dear Sir, When ever I use BULK COLLECT feature to collect thousands of rows from a table PGA memory is running Out of scope. Here I have a table named...
hi all I am doing a project to send mail from oracle9i and forms6i using SMTP_UTL package . My mails are going but a problem is that i want send a attachment...
It is very well possible if you use load Java Mail API from SUN, into the db, using loadjava utility. Infact, I have implemented this, and it works. ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
