Recent content by Johan Visser

I think that it would be a great enhancement to have a multi-connection session component. Example: Connect to 2 (or more) different databases. Set the active session to the first database. Set the session of a query component to the multisession component. to switch between databases...

Hello, This looks like an Oracle problem. Oracle 8 and up uses a different TNS names file. For Oracle 7.xx this file is located in \ORANT\NETWORK\ADMIN\ For Oracle 8.xx this file is located in \ORANT\NET80\ADMIM\ When upgrading you must create a new TNSNAMES for Oracle 8 with the same aliases as...

Hello, I've tried your code and it works just fine. Is the procedure in the database valid? What are the settings for the OraclePackage component and for the Session component. Greetings Johan ------------------ JohaViss

Just use a Package and a Query type ... DBMS_DDL: TOraclePackage; Proc_Items_qry: TOracleQuery; ... public ... procedure Recompile_All; end; and use this procedure: procedure TDataModule_Procs.Recompile_All; var Param1, Param2, Param3: Variant; begin with Param0_qry do try...

I have tried the same statement and I had no problems. What are the datatypes of the variables used in the query. Are they the same datatype as the columns in the table? Also, what are the datatypes you pass to the variables from your program. Greetings Johan ------------------ JohaViss

To make a query return only the records you want, you want the query to look like this: select COLUMN from TABLE where rowid in ( select rowid from TABLE where rownum

How can I cancel a running query? The manual tells me to use BreakExecution, but it also says that that procedure must be used in a multi-threaded application. My application is NOT multi-threaded. Is there still a way to cancel my query??? ------------------ JohaViss

When I try to access a table that contains Julian dates (01/01/4712 BC) I get an error. "Invalid argument to date encode" I'm using a stament like this: "select * from My_Table" My_Table contains a date field, and some of the records have a Julian date. (01/01/4712 BC) Is there a way to use...

This solution works perfectly. There are 2 things that can cause problems (as far as I can see for now) 1) If you choose for a PL/SQL table, make sure that the tablesize is big enough to hold all the data. If you don't, Oracle returns a ORA-06512 2) You must check if there is a value returned...

I'm trying to get a describe of a stored procedure using the 'DBMS_DESCRIBE' package. I'm calling the procedure 'DESCRIBE_PROCEDURE' with the correct number of parameters but I get an error "Wrong number or types of arguments in call to 'DESCRIBE_PROCEDURE'" How can I use this package to get...