• COmplex update takes a 90 minutes to run in Oracle

    In the following procedure, the update is taking 90 minutes. The client table has 22 million records, the CPDS table has 40 records. It has been written by someone else, I don't have access to Oracle so can't check my thinking, but I believe, if we select the data to be updated into pl/sql tables,...

    Abhigreen10 pointsBadges:
  • Error(7,30): PLS-00103: Encountered the symbol “OUT” when expecting one of the following

    I am getting this eror when i compile my procedure with OUT Parameter ,it has got several OUT param ,but only this particular line pops up err msg Error(7,30): PLS-00103: Encountered the symbol "OUT" when expecting one of the following: := . ) , @ % default character The symbol "," was substituted...

    Inprise610 pointsBadges:
  • Oracle Forms 6i: image in menu bar

    our requirement is to display the company logo in the menu bar so that it is always visible to the user while working in application. any way or workaround? thanks in advance. we are using forms 6i

    Dilshadch5 pointsBadges:
  • program too large ( D2K form builder)

    i have written some code in D2K 6i form builder, in a button trigger name is " WHEN_BUTTON_PRESSED". While compiling I am getting an error program too large. plz answer.

    44063860 pointsBadges:
  • Select/Insert Statements causing out of memory error run under VB Script

    I'm using VB Script on a Windows 2003 Server against an Oracle 10g database to both query against a table and insert new rows of data against that same table but as it runs it starts eating up RAM and when it gets to about 1.5gb it causes the out of memory error.  As far as the Select...

    TheBandit15 pointsBadges:
  • Earn 250 Knowledge Points now by tweeting out our contest

    We've recently added 250 Knowledge Points to the following profiles for tweeting out our Google Nexus One Challenge: JaideepkhandujaOwenAmbroseCarlosdlRyan8613MarkK Tweet out our Google Nexus One Challenge now and you can also earn the 250 Knowledge Point bonus. Remember that you don't have to be...

    JennyMack4,280 pointsBadges:
  • Reports Are Hanging in Oracle 10g

    When Iam Opening Repots Some Reports Are Hanging Due To Heavy Coding ,At The Same Time When I Started To Run A Simple  new Reports That Is Also Hanging  What Is The Problem ,And Give Me Solution.

    Gopibuchi5 pointsBadges:
  • Oracle Hyperion error message

    The requested document does not exist in the repository

    Sudsy5 pointsBadges:
  • In DBCA, Its not Showing all the database in the list

    In DBCA, After selecting the " ORACLE SINGLE INSTANCE DATABASE" and Click next Button, There In list of Available database its not Showing all the database in that server Please let me know where we specify those database name to be picked by DBCA, I have checked in TNSNAMES.ora & LISTENER.ora but...

    Ganeshpp5 pointsBadges:
  • Will Java CAPS survive when Oracle Fusion releases?

    Will JAVA CAPS survive when ORACLE FUSION RELEASES? HI, RECENTLY I HAVE JOINED IN ONE ORGANIZATION. THE COMPANY IS USING THE JAVA CAPS AND EGATE. I CAME TO KNOW THAT IF ORACLE FUSION RELEASES JAVA CAPS MAY NOT USES BY ANY COMPANY. PLEASE GIVE ME SOME IDEA ON JAVA CAPS AND ALSO TELL ME THAT DOES...

    Narayana6765 pointsBadges:
  • Upgrading for database structure

    hello everyone  Maybe my previous question was not the correct question to ask. I am in the middle of making an application upgrade which includes DB structure upgrade with keeping Data "data loss is not accepted here". I have a complex DB structure in my application which depends "in some...

    Mshafie70 pointsBadges:
  • Application Upgrade and Data migration

    Hello Sir/Mam We have a web application that has an intensive usage of Database operations. This application of course has some sort of sophisticated Database (tables, indexes, ...)  structure according to Database engine used.  My question now is , what is the best practice to migrate old...

    Mshafie70 pointsBadges:
  • How to call report 6i from forms6i defining the username/password

    I am using forms6i and Report6i, Now I am trying to connect to another user to run the report. How to call report 6i from forms6i defining the username/password

    Praxman5 pointsBadges:
  • Sybase to Oracle

    If I move a database from Sybase to Oracle with no coding changes what is the impact on the target database with respect to CPU, Memory, IO, etc?  Note that the OS will go from Solaris to LINUX also. 

    Cgardel30 pointsBadges:
  • Converting Oracle Report 6i into Excel

    the problem is in report the data is correct but when i try to convert into excell the dupicate rows are beuing formesd..i also did a page protect variation but report changes but not the converted file. if i have 50 records on page 1 then in report it shws 50 rows only but in xcel it shows 55 rows...

    Programmerjan35 pointsBadges:
  • IT Knowledge Exchange’s iPad Contest Starts Today!

    Today marks a new contest around IT Knowledge Exchange. The Lowdown (i.e. The Rules**) Every member who earns 500 knowledge points in the next 4 weeks (between today and Wednesday, February 16th) will be entered into a drawing for 5 names. You must have a completed profile including a photo or...

    MelanieYarbrough6,345 pointsBadges:
  • Oracle Reports Builder

    Hi, i have one query plz help me on the same.... I am creating the report in oracle report builder 6i,  i made every thing but i stuck on one problem. it is i used group by command in sql query. i got the total of one column. but in that column there are no. of same customer name in a month which...

    Ss66015 pointsBadges:
  • Oracle Forms 10g- which is the correct one to use- NEW_FORM or CALL_FORM?

    WHich is the best option to use when developign forms for the web? 

    jkeri360 pointsBadges:
  • unable to run the form 10g

    unable 2 run the form 10g. while i am runing the forms itis displaying "oracle forms " and hanging any one plz help me

    Oracleapps0340 pointsBadges:
  • Oracle 10g – running forms in web browser

    My users run forms in 10g in the web browser (IE v7). Sometimes when they navigate away from the browser to do something, or a form is runnign a long time, and then return to the browser, the area that had the form showing is now covered in grey. Question: 1- what causes that 2- how do we avoid...

    jkeri360 pointsBadges:

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:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following