• NUMBER IN A LIST

    I am trying to do an update statement with a where clause that has a number table column in a string list. The string when displayed is ####, ####, ####; with no quote marks. This is in a when-button-pressed trigger in a form. It appears to work when the list only has 1 number in it, but returns...

    Papalpha5 pointsBadges:
  • Link Between MTL_MATERIAL_TRANSACTIONS and GL_INTERFACE in Release12

    I'm in an upgrade project from 11.5.7 to 12.0.4, the client has some major customizations using the existing link between MTL_MATERIAL_TRANSACTIONS and GL_INTERFACE like the reference21 in GL_INTERFACE = batch_id in MTL_MATERIAL_TRANSACTIONS and the reference23 in GL_INERFACE = TRANSACTION_ID in...

    Tanque5 pointsBadges:
  • Oracle EBS pritner

    Why printers connect to EBS often disabled? It looks like in a couple of day an Oracle user will report she can't print a check or a report. EBS=11.5.10, Linux, 9i.

    QAQA65 pointsBadges:
  • Oracle initialization error while running Java files

    I am facing no issues while compiling the java file. However while running the same, I am facing the following error. java.sql.SQLException: ORA-01033: ORACLE initialization or shutdown in progress. Any pointers for the same?

    JagdishK5 pointsBadges:
  • How can we startup our DB if any one redologs is corrupted totally 2 redologs

    how can we startup our DB if any one redologs is corrupted totally 2 redologs.the corrupted redo is in archivemode.1st redo is corrupt tat is in current use of archive mode

    Kkvsaathish5 pointsBadges:
  • 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:
  • connection of oracle8i i vb6.0

    how to establishconnection of oracle8i i vb6.0

    Wasim5 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:
  • Call Oracle Store Procedure from Reporting services

    Can u please tell me how to call a oracle stored procedure that accepts 2 in parms and returns a Ref cursor as out parameter exmple: CREATE OR REPLACE PROCEDURE GetReportData ( Id1 IN NUMBER, Id2 IN NUMBER, resultSet OUT sys_refcursor )

    PramodSR35 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