• I would like to know the procedure name

    How to know the procedure name of itself? for example, ------------------------------ create or replace procedure my_proc1 is begin dbms_output.put_line (' procedure name =>' || xxxxxx ) ; end; ----------------------------- i want to print 'my proc1' as procedure name through...

    Gregori15 pointsBadges:
  • ORA-12560: TNS:protocol adapter error

    I recently downloaded Oracle Designer from oracle website. When I use the default username and password, it give me the following error ORA-12560: TNS:protocol adapter error RME-00220: Failed to connect to Repository What should I do to solve this problem

    Develolper5 pointsBadges:
  • Oracle forms app run on Client

    Hi, I have an application migrated from DS6i to DS10g. I can run it from the server where i have installed all required product. I want to run it from my client PC. I have installed JINI on client. But i can not run my app in client IE Browser. What kind of setting i have to make in Client side...

    Kelp115 pointsBadges:
  • Urgent Help

    I have some doubts related to oracle database..... I am in ECC 5 implementation project (OS: Windows, DB: Oracle) My Question....... After Installing ECC 5 the default database size is around 50 GB, some 300 GB HDD is allotted to database , the client is saying to utilize the remaining 250 GB (300...

    Abtest0 pointsBadges:
  • do_while how can i use do while statement to delete certain rows based on the rowcount?

    how can i use do while statement to delete certain rows based on the rowcount??

    Mahe10 pointsBadges:
  • How can I get my Oracle load script to recognize decimal data with a trailing minus sign?

    I am writing an Oracle control file (load script) that will read a data file that contains multiple decimal fields that have trailing minus signs for negative numbers (there is a space for positive numbers - there is no plus sign). The records are fixed length, but the decimal numbers aren't a...

    BillWillis5 pointsBadges:
  • ERP Finance Consultant

    What is the job skills required for an ERP finance consultant

    PN1510 pointsBadges:
  • oracle – automated testing tools

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

    Rm120 pointsBadges:
  • oracle 9i instalation

    hello guys I have recently started learning SQL and I am trying to install 9i (database or software where I can practice SQL quires). Long time ago I started learning SQL on that time it was personal oracle7 I installed and used to do my practice...but now I have heard that you can install 9i on...

    11g5 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:
  • update date value in oracle 9i

    What is the code to update a date value in oracle 9i from vb.net

    Venomwi5 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:
  • 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:

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