• 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:
  • Replication manager

    where to find replication manager to install with oracle 8i

    Krishmurali5 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:
  • SQL Plus

    I have a subquery that works but I need to change some parameters. Specifically 2 fields in a different table. When I do, using aliases, it stops working, "Invalid Identifier". The first select gets all the fields from 2 tables then the subquery uses the 2nd table. Table B has some fields as well...

    Gator255 pointsBadges:
  • Oracle Reference to Table_Name, Column_Name, etc by reference to variable

    Does Oracle prohibit reference to Table_Name, Column_Name, etc by reference to a declared variable? I am trying to create a simple routine to print documentation whenever any changes are made to the database using the following routine: DECLARE CURSOR Table_cursor is SELECT * FROM TABS WHERE...

    Sweetpea0 pointsBadges:
  • constraints

    sir ,how can we find tables those which are related each other exactly(while training) not apps tables ,simply in 9i db environment(user defined tables)

    Maneswar15 pointsBadges:
  • how can i update ?

    when update in form (master_details) in details block i found error frm-40735 when button pressed trigger raised unhandled exception ora-00001

    Camba5 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