Recent content by foldenm

  1. F

    Join-Statements

    What version is your Oracle Database? "Right Outer Join" syntax is supported in Oracle 9i, but not Oracle8i or earlier. Try this: select iasmatfms.material, iasmatfms.statmatnum, iasmatx.stext, iasmatx.ltext from iasmatx,iasmatfms where iasmatfms.material = iasmatx.material(+) The (+) on the...
  2. F

    Small request for enhancement

    Thank you. It will be very helpful. Keep up the great work... mdf
  3. F

    Small request for enhancement

    I really like the QueryReporter. It is very fast and flexible. Would you consider adding the ability to allow for a "command line" parameter of parfile=abc.txt where abc.txt would contain the list of parameters like this: userid=mydatabase/mypassword@myserver exec=myreport.rep...
  4. F

    TOracleScript and a Threaded Query?

    Hi. I'm currently using a TOracleScript component to run scripts invisibly, and capturing the output via the "OnOutput" events. Everything works great so far. Since I have access to the Query component of the TOracleScript, can I turn this into a threaded query, and catch the output via the...
  5. F

    Is it DOA bug?

    Hi. I looked up an explanation of the error in Oracle Metalink. They gave the following answer: Error: ORA 3120 Text: two-task conversion routine: integer overflow Cause: An integer value in an internal Oracle structure overflowed when being sent or received over a heterogeneous...
  6. F

    ORA-01019 Error

    This message can be very misleading. If you are not accessing a previous release of Oracle (i.e., 7.3 to 7.2, 7.1, 7.0) from a higher release and there are no apparent memory or swap problems, the ORACLE_HOME and/or ORACLE_SID may not be set correctly.
  7. F

    error editing OracleDataSet table

    Hi. Look for some of the following problems: 1) Column is a calculated column. 2) Column in table was created with double quotes (making it case sensitive) 3) Column contains special characters, such as # If any of the above are true, this could lead to Oracle not recognizing the...
  8. F

    INSERT and the RETURNING Clause

    Try using the following syntax: INSERT INTO MYTABLE(a,b,c) VALUES(1,2,3) RETURNING a,b,c INTO :v1,:v2,:v3;
  9. F

    Problem with TOracleSession

    Try checking the Session.Connected property. It will tell you whether or not the session is actively connected to a database...
Back
Top