The OraDAC Generator is a useful code generator which generates source code units for Delphi based on ADO database objects for Oracle database packages. For each oracle package generates one unit with class that represent oracle package.
Methods of this class are equivalent to oracle's package procedures and functions. Also it's generates "main unit" that contain main class TMyOracleDB. TMyOracleDB class contains ADOConnection and packages classes.
How to use?
Include uMyOracleDB.pas generated unit into your project
Create instance of TMyOracleDB class
Db := TMyOracleDB (self);
Connect to database
Db.Connect('user', 'password', 'database');
call Your procedure!
Db.MyPackgae.MyProcedure(1, 'test', nil, TBlobByteData(buffer));
Limitations:
· 30 days trial