HMGforum.com

Hello,

I need to write some applications that connect to an Oracle database. I have created a wrapper function that can do this but it is very kludgey. It writes a SQL script on-the-fly, runs the script in SQLPlus then gets the output via a spool file. Yuck!

Is there an easy way to interact with an Oracle database using HMG?

The versions I need to access are 10g and 11g.


Thanks,

Michael

melliott42 wrote:Hello,

I need to write some applications that connect to an Oracle database. I have created a wrapper function that can do this but it is very kludgey. It writes a SQL script on-the-fly, runs the script in SQLPlus then gets the output via a spool file. Yuck!

Is there an easy way to interact with an Oracle database using HMG?

The versions I need to access are 10g and 11g.


Thanks,

Michael

I've never used Oracle, but I guess that it could be done via RDDSQL.

Look at \hmg\samples\rdd.sql\mdb.

If you can get an ODBC connector for Oracle and modify the connection string as required, it could work.

Hi Michael
you can see in http://www.connectionstrings.com/oracle
best regards,
Luis Vasquez

Hi,

Interesting link about it

http://www.ajpdsoft.com/modules.php?nam ... le&sid=272

Regards,

MigSoft

Hola Miguel,
como siempre, un excelente aporte.
Gracias.
Saludos cordiales,
Luis Vasquez