• oracle – automated testing tools

    what automated tools can be used to test oracle forms application and oracle database backend

    Rm120 pointsBadges:
  • Resetting the database

    I received the following error:RMAN-20042: invalid tablespace creation change# when i dried reseting the database after doing a restore from an Rman backup. I tried to unregister the database than register it back in rman but the problem still exist and getting the following even when i try to...

    Oradbsm5 pointsBadges:
  • Why do IT projects fail?-3

    Hi, I'm a Computer Engineering at CSU Chico. I'm conducting a research paper on "Why IT Projects Fail". If someone could give me an example of a failed projects, "failed" meaning that it didn't get finished on time, or the final project did not meet the requierments. Also if you could give a quick...

    Dbrazeau10240 pointsBadges:
  • Nested Case statement in Oracle BI

    I am trying to create a nested case statement in Oracle BI (9.0.4) the statement works when I do it in Oracle SQL*Plus but will not let me keep the whole script in the Calculation.What do I need to doo to have this work in Oracle BI? The statement is as follows: select emp_name, (CASE WHEN...

    Nanapap5 pointsBadges:
  • Oracle driver

    Do you know if a 32 bit oracle driver works on 64 bit computer?

    Alediamo10 pointsBadges:
  • How do I stop my VB6 application on a Windows2003 server using up all the connections on my 9i DB?

    The root of the problem seems to be w3wp.exe interacting with the 10g client we use to attach to the 9i DB (due for upgrade to 10g soon). I can't really change the VB component since it's also required to run on Windows2000 - which it handles with no problems against the same DB. Also can't upgrade...

    Alexanderph5 pointsBadges:
  • CRM on demand versus on premises solutions?

    Can somebody give a quick comparison of CRM on-demand solutions vs on-premise solutions regarding their integration capabilities with ERP and other legacy systems such as SAP, Oracle Apps?

    CRM Ask the Expert250 pointsBadges:
  • Oracle Named User licenses required for load testing

    I want to do load testing of an third party application on an environment with an oracle named user license. Assuming I am going to use a load test program like LoadRunner, what is the relationship between the number of virtual users in the load test and the requirements for Oracle licenses on the...

    Emison5 pointsBadges:
  • Thin Provisioning ?

    Interested in any feedback regarding the viability of Thin Provisioning ( via FC SAN attached, not NAS)in a large scale environment. Items of specific interest related to Win2k03,AIX Oracle/MSSQL What vendors solution are you using? Has it worked as expected? Has the added value of T.P overcome any...

    LostinStorage0 pointsBadges:
  • PL/SQL – select data – group by- having?

    I need to select all names where Value EITHER a or b. how do I do that?/thnks Sample: Num Name Value 1 Ann a 2 Ann b 3 Julia a 4 Julia b 5 Peter a 6 Jnohn b

    Julctm15 pointsBadges:
  • Not Return Any Record if Value Exists

    If I have a table that has the following data (f1 & f2 are the field names): f1 f2 a 1 a 2 a 0 b 1 b 2 b 3 I want to write a query that would not return b because b has a f2 = 3. So, in other words: I have a table with many records for each id. I do not want to return any records if the id has a...

    Rjwilcox45 pointsBadges:
  • Login error for workspace

    Hi All, I have installed and configured hyperion system 9 BI+. I can login shared services and essbase with admin/password. But i cant able to login workspace. 1.Is there any default username and password for workspace? 2.If not what are the steps to create login and password for workspace? Thanks...

    Malky5 pointsBadges:
  • date functions using Oracle

    Hi, I need to display the benefits paid for the current year using SQl,but the year is filtered using the year which is previous year for the current year.the date is in 'yyyymm' format. ex, select year_mnth,benefits_paid from tablename where year_mnth in ('200603','200602','200601') note:it is in...

    Maha15 pointsBadges:
  • to write code

    i have created a table "stu" in which the following record exists. stu_id,stu_name,stu_course,stu_marks the stu_marks column output is as follows 822 758 789 658 822 879 598 825 589 785 795 795 658 789 988 what i want is to write query or code (function,procedure or anything) that when i execute it...

    Daudkhan5 pointsBadges:
  • my question

    How to find the repeating charactar or letter in a string like 'information' in pl/sql or sql .

    Maneswar15 pointsBadges:
  • PLSQL based method to capture emails from POP server

    I am using UTL_TCP package of PLSQL. I am able to connect to the POP server but I am unable to retrieve any email content. Using the UTL_TCP.available() method, I am getting the returned number of bytes as Zero inspite of their being an email. I tested the telnet commands againt the POP server &...

    Monk10 pointsBadges:
  • how can i resolve oracle error 00103

    I am getting the following error when running the below procedure from TOAD. I have ora 9i OS Windoes XP. CREATE OR REPLACE PROCEDURE SP_CALL_PROCEDURE22 (BUSINESS_UNIT1 in varchar2) IS CURSOR C1 IS SELECT BUSINESS_UNIT,VOUCHER_ID,INVOICE_ID,VENDOR_ID,GROSS_AMT FROM PS_VOUCHER WHERE BUSINESS_UNIT=...

    150919745 pointsBadges:
  • batch queries in oracle

    We are developing a .NET web application and have decided to use CSLA as our business architecture framework. Because CSLA is based on Microsoft technology, it is designed to work with MS sql. Much of the framework uses batch queries to grab multiple result sets in one query but it appears that...

    Dhworth5 pointsBadges:
  • SQL query ORACLE report “Active Users”

    I have problems analysing the standard Oracle report "Active Users". I want to get my users into excel but the report lay out sucks. How can i get this report directly from the database?

    Jkort5 pointsBadges:
  • ORA-02068 and 03113

    I have dblink in local database 10.2.0.3 pointing to remote database 9.2. There is a view in local database which is based on tables on remote database using dblink. When I run the select on that view, it fails with ORA-02068 and 03113. It works intermittently. It works most of the time with less...

    Skkumar25 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