Please note of this bug: http://quality.livecode.com/show_bug.cgi?id=18583
In order to connect to a OracleDB, you need a commercial (business) version of livecode, because the oracle drivers are proprietary. The connection is:
put revOpenDatabase("oracle", DBHOST_Oracle, databaseName, DBUSER_Oracle,DBPSWD_Oracle) into gConnectionID_Oracle
where:
- Databasename is the name of the database
- DBHOST_Oracle is the internet/local address of the database, you may specify also a port
- BUSER_Oracle is the user name
- DBPSWD_Oracle is the user password
Example:
put revOpenDatabase("oracle", "www.example.com", "MyDB", myUsr, myPass) into cID