Delphi Array to Oracle Database
I have a Oracle Package:
CREATE OR REPLACE PACKAGE Array_Test
TYPE my_array IS VARRAY (10) OF String;
PROCEDURE proc_array_test (
p_param1 IN Varchar2,
p_array IN my_array);
In Delphi I created an array
InfoArray : array[0..9] of String;
and would like to pass InfoArray to the Oracle Package Array_Test as a parameter. How do I do that?
dmMyDatamodel.stpMyStoredProcedure.ParamByName(‘p_param1’).Text := ‘TESTING’;
dmMyDatamodel.stpMyStoredProcedure.ParamByName(‘p_array’) ???????? .... this is where I get stuck.
I'm using DBExpress.
...Good (Free) Database Choice For Simple Local Database For Delphi 2009
For years I have used the BDE and dVolga ( no longer abailable ) but want to
learn how to use other third-party and/or Delphi 2009 vcl components for
For a simple local database with only one table and 6-8 string fields with
graphic field support for one field what is a good choice?
What is available to do this without buying anything or possibly with a
Should I use DBExpress?
Is a commercial database application necessary to create the database?
Is something available from Microsoft as a free download to create and
possibly edit a...dbExpress/ Delphi 10 trial/ Oracle 10g local Database
I get a "BCD Overflow Exception" when executing a SQL-Query on the delivered Testdata of Oracle ( local Database 10g) / User HR / Table EMPLOYEES and passing the result to a ClientDataSet. Obviously the Field "COMISSION_PCT" causes the error. When excluded, it works.
I appreciate if anybody knows a solution.
...Oracle Database vs Access Database
I am eventually planning on moving from an Access database to an Oracle database. I have no idea how to do this from the beginning. I know they both use SQL statements, so maybe I would just need to mirror an oracle database after my access and change the connection strings? If someone could answer some questions or point me to a post or web link that describes this in good detail1. How much are oracle databases and where would I find one to download?2. How much more can they hold than access databases?3. Will it be easy to move all my data over or would I have to change a lot with my sql st...Amazing database for Delphi
In the past I used many databases with Delphi, like sql server, Interbase, BDE and many others, Last year I had standalone project for a Church, the project wasn’t that big, but had
thousands of records with a lot of big tables. To avoid any dependencies “BDE, DLLs, servers etc.” I had to find small, compact, and compiles right into my EXE.
However, after I looked around (you can find my post on this site), many developers recommended Absolute Database, so I tried it and the price was very good, I surprised how this database handles very advance and complex queries and very fast.
I re...delphi 2010 database
I’m new to this forum, currently I have application with MS Access and all works good for me.
But I need more reliable without DLL or other dependencies (for Delphi 2010)
I found many databases for Delphi,
I prefer free or less than $100.00
On 2010-11-28 19:09:31 -0500, Falah Latino <> said:
> I’m new to this forum, currently I have application with MS Access and
> all works good for me.
> But I need more reliable without DLL or other dependencies (for Delphi 2010)
> I found many databases for Delphi,
> I prefer free or less tha...Database with Delphi XE3
I've been using Delphi 7 Pro for years and have had to deal with the PDOXUSR.NET access denied problem with Vista OS and up anytime my application uses the Borland Database Engine. I'm thinking of buying Delphi XE3. Can someone tell me if the PDOXUSR.NET Access Denied problem has been taken care of in this version? With Windows 7, it seems that my apps will only run if I have the user reduce their User Account Control to a level the access is no longer denied. I'm hoping this is not an issue with XE3.
I'm sorry if this is not the proper forum for my question. I there is a be...copy database one database to onther database
hii want to copy one database table to onther database table using script?my database is ms-sql server 2000 Nothing is really over,untill the moment stop trying for it...Amitsp(MCTS,MCP)sqlreporting.blogspot.com
You can use import/export task and DTS package created automatically by Enterprise manager or just try
select * INTO [newdatabase].dbo.[newTable] from [sourceDatabase].dbo.[sourcetable]
no dear i want to this programatticallyiusing c #,source is my database in local machine and target is other computer means server Nothing is really...Delphi embedded Database with Pivot
We currently have a database app that works with Microsoft SQL Server. We want to have the option of switching to a native Delphi database to ease deployment issues.
All our code is standard SQL, except for the call to the PIVOT command, which we need, and seems specific to SQL server. Do any of the native delphi databases have commands similar to Pivot?
David Novo wrote:
> We currently have a database app that works with Microsoft SQL Server. We
> want to have the option of switching to a native Delphi database to ease
> ...How to upgrade database changes in remote databases and consolidated databases
I am Working in a project which uses Sybase Mobilink server as the
replication system. Now I have been given a requirement to automate the
upgrade databases chages in remote databases and consolidated database.
I heard the about "Passthrough" but I don't know how to use it.
I saw below topic in our forum
PASSTHROUGH Question. How do I replicate DML ...
1.- Created a Version_Tracking Table (contains columns
Unique_Record_ID, DB_Remote_ID, DB_Version, DB_Update_Time_Stamp and
2.- The new Version_Tracking table is part of a publication that...Delphi and Delphi for .Net
It seems that Delphi for .Net is slower than Delphi Win32 native applicaiton.
I would like to know is it true all .Net application is slower than Win32 native applicaiton or it is Delphi for .Net only.
Your information is great appreciated,
On 2011-06-21 18:20:17 +0100, Inung Huang said:
> It seems that Delphi for .Net is slower than Delphi Win32 native applicaiton.
> I would like to know is it true all .Net application is slower than
> Win32 native applicaiton or it is Delphi for .Net only.
If you are only running the code in the application once then, yes, yo...Migration from Oracle database to a Sybase 11.5 database
Is there a way to export an oracle database and import it into a sybase 11.5
The way to go would be
1] Generate the DDL of oracle_db using Erwin or similar case tool . Erwin
allows you to generate Sybase compatible DDLs
2] Copy out the records of all tables into flat files using a Oracle
3] Create the Sybase database .
4] Create datbase objects using the DDL generated.
5] Copy the records into Sybase database using Sybase BCP utility.
I am not very familiar with Oracle ,so I wont be able to guide you much on
Try to copy out the record...how to access other database in this database ?
Hi,Everyone,I used to use oracle 8i,but now for some reasons,I must change
to ASE11.5,at the beginning,I don't know how to access tables among
databases,in oracle, if I grant "select" to some user,this user will access
other user's table in username.tablename format,I want to know how to
implement this functions,please help me! thanks!
Very similar in sybase ASE.
grant SELECT on <user>.<tbl> to <newuser>
for new user:
select * from <user>.<tbl>
> Hi,Everyone,I used to use oracle 8i,but now for some rea...Backup a MySQL database from Delphi
Is there an easy way to backup/restore a MySQL tables from my Delphi application. The database is hosted by my Web host. To remotely connect to my MySQL database, I use ADO (dbGo tab) components. My tables use MyISAM.
Can I use mysqldump or mysqlhotcopy from Delphi via ADO?
BTW, I use Delphi 2009.
> Can I use mysqldump or mysqlhotcopy from Delphi via ADO?
mysqldump does not need any additional connectivity layer,
like ADO, ODBC or what else. mysqldump uses TCP/IP
to connect to MySQL server.
So, all what you need:
- mysqldump of the your MySQL server version;
- run mysqldum...