Connecting to an Oracle Database

[melliott42]

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

[Roberto Lopez]

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.

[luisvasquezcl]

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

[MigSoft]

Hi,

Interesting link about it

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

Regards,

MigSoft

[luisvasquezcl]

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