Zeoslib Portal

First of all, Its so complex for me. I try to change some piece of code to see if its possible CAST/Convert ref cursor (POCIStmt) parameters to IZStatement and/or IZDataset like TNestedDataset; Ill attach my code... (no complete yet) (ZDbcOracleStatement line 819) .... case CurrentVar.TypeCode of SQ...

I propose add stCursor at ZDbcIntfs.TZSQLType TZSQLType = (stUnknown, stBoolean, stByte, stShort, stInteger, stLong, stFloat, stDouble, stBigDecimal, stString, stUnicodeString, stBytes, stDate, stTime, stTimestamp, stAsciiStream, stUnicodeStream, stBinaryStream,stCursor); It will be possible to supo...

I have some procedure into oracle packaege that work fine. This days I receive from DBA one procedure that OUTPUT a Ref CURSOR. Pkg_test.procedure( listParams IN , refCursor OUT ); http://asktom.oracle.com/pls/asktom/ASKTOM.download_file?p_file=6551171813078805685 http://www.oracle-base.com/articles...

My sugestion: create a new group at SQL Servers and Databases... There are for others databases, but not for Oracle. New group for Oracle Topics will be possible ?

Ill Try, I have a lot of code working with BDE (Borland). I like a lot how zeoslib work and I work in it to solve some problems... Than I was thinking... If zeos have the same interface of TQuery, TDatabase, TSesssion.... and others... is it possible to compila BDE and with the same code compile to ...

I Have a procedure like: procedure my_proc( v out number); When a execute with TZStoredProc I have an exception. I Change this code in ZDbcOracleUtils line 414 (in red); procedure LoadOracleVars(PlainDriver: IZOraclePlainDriver; Connection: IZConnection; ErrorHandle: POCIError; Variables: PZSQLVars;...

Translate BDE interface to ZeosLib.

To mirror of BDEConfig, run procedure: ChecaCreateZConnection(false); It will create ZConnections.ini with zeos config.

Thanks for you attent... Actual the code is the same of: link: http://zeos.firmos.at/viewtopic.php?t=3264&start=0&postdays=0&postorder=asc&highlight=oracle+procedre+output I restart my work in this code last week. I have problem to get output params from oracle procedure. If you have...

Changed Oracle implementation StoredProc+Functions Rev. 938 to improve some point of Delphi IDE Component.

Eu tinha uma instalação completa no notebook... e não conseguia conectar... Removi tudo, e depois baixe o "InstantClient"... http://www.oracle.com/technetwork/database/features/instant-client/winsoft-085727.html Depois de algumas pesquisas encontrei um site que indicava como instalar o Ins...

O meu TNSNAMES.ORA.... esta assim: store = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.172)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY = 5) ) ) ) no Forms: objec...

- Implement Oracle 10g StoredProc and Functions. (ExecSQL);
- Implement IDE functionalities
TZStoredProc->StoredProcName; TZStoreProc->Params

I Finished first code to Oracle 10g StoredProc and Functions.
I dont known where I can upload...

- on Delphi IDE, can select StoreProcName and Params (on Inspector).

I have worked to provide some functionalities to ZeosLib 7 to ack like BDE components.
I have a lot of code working with BDE and want to change BDE to ZeosLib.
To goal this, I'd write BDE's inteface...
For now I have success with and would thanks ZeosLib Team.

Remove IP server. TZConnection use TNSNAMES to connect.

Like this:

object ZConnection1: TZConnection
Protocol = 'oracle'
Database = 'dbrhm'
User = 'dbrhm'
Password = '123456'
end