Zeoslib Portal

Hello! That's exactly what I want. However, the TZSQLMonitor returns SQL without parameter values ​​substituted. It replaces the parameter name with the symbol "?". Example: SELECT CD_PERSON, NM_PERSON FROM PERSON WHERE NM_PERSON LIKE ? What I really want to see is the SQL with the paramet...

Hello!

The TZQuery/TZReadOnlyQuery provides a method that returns the SQL with the parameter values ​​replaced?

Josimar

I have searched on the internet the term "connect to oracle without tnsnames.ora". I noticed that you can connect to Oracle without the need to configure a TNSNAMES.ORA . However, ZEOS appears necessary to have a TNSNAMES.ORA configured. There is the possibility of connecting the ZEOS with...

Hello railgun3r! To order queries with TZQuery I prefer to use the properties SortedFields and SortType . For example, a query with the following: SELECT CODE, NAME, BIRTHDAY, ID FROM PERSONS WHERE NAME LIKE '%Osama%' To sort the ascending the NAME field, do the following: ZQuery1.SortedFields := 'N...

Hello! I have an Oracle server with various schemes. Two of them are called: JOE FRANK On the client computer I installed the Oracle Instant Client and TNSNAMES.ORA configured as follows: MYORA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dev.orcl.com)(PORT = 1521)) ) (CONNECT...

Hello marsupulami! Exactly! For you to compare Bookmarks of sorted Query's you need to do the type casting of pointer to PInteger to scroll through the records to find, as you did in the previous example. This technique may consume too much processing on queries with a large amount of results. I do ...

Hello! Primarily I want to apologize for the inconvenience of the previous posts. I'm starting to develop in Oracle + Delphi and I'm finding some difficulties. In this case mentioned I assumed to be a failure because Zeos had sought help in the Oracle fóruns and according to the responses I received...

Hello marsupilami! I understand that when you order the result, the Query lose your references and create new references. Once I have problems to compare the bookmarks of a query with a structure previously stored pointers. I got satisfactory result when I tried the the pointer as a pointer to integ...

Hello! I have some more useful information about this error. When told explicitly the table schema in SQL, the TZOracleDatabaseMetadata.UncachedGetColumns method receives information from the scheme in the parameter SchemaPattern : SELECT * FROM RYO.EXAMPLE One option is to check if the variable is ...

Hello marsupilami! Use TList structure to store Pointer types and use GotoBookmark method: List := TList.Create; try ZQuery1.Open; ZQuery1.First; ZQuery1.SortedFields := 'ID'; while not ZQuery1.Eof do begin List.Add(ZQuery1.Bookmark); ZQuery1.Next; end; ZQuery1.SortedFields := ''; for x := 0 to List...

I found an apparent solution to the problem. The UncachedGetColumns method in TZOracleDatabaseMetadata class in ZDbcOracleMetadata unit uses the ALL_TAB_COLUMNS VIEW in the SYS SCHEMA. According to a handbook for the Oracle DBA, VIEWS that start with "ALL_" "accessible by all users, g...

Hello! Debugging the code Zeos I found some useful information. The method TZOracleDatabaseMetadata.UncachedGetColumns in ZDbcOracleMetadata unit runs on an SQL statement that fetches the information table in the SYS Schema: SQL := 'SELECT NULL, OWNER, TABLE_NAME, COLUMN_NAME, NULL, DATA_TYPE,' + ' ...

Hello! I have an Oracle database with three users/schemas. The three schemes have similar structures. I'll call them Joe, MAX and RYO. My application access the database using the component TZConnection . In particular form have a TZQuery with a simple SQL: SELECT * FROM EXAMPLE The user clicks the ...

Hello mdaems,

As I was on vacation could not answer it before.
Performed tests with SQL that were presenting the message OCI_SUCCESS_WITH_INFO and run successfully!

I will continue making tests and any news will let you know. The principle is fixed.

Tank you!

Josimar

Hello francis.rangel!

In the TZSQLProcessor component change Delimiter property to $$ and change the DelimiterType property to dtSetTerm.

Try!

Josimar