Recent content by foldenm

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...

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

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...

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...

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...

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.

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...

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

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