User`s guide

2 Getting Started with Database Toolbox

2-124

'Server','sname','PortNumber',123456);

Or, if you have trouble using the database function to connect to your Oracle

database, try using the full entry in your tnsnames.ora file in the URL string as

one consecutive line. Leave the first argument blank. For example, the following

code assumes the value of the URL name-value pair argument is set to the following

tnsnames.ora file entry for an Oracle database.

conn = database('','username','pwd',...

'Vendor','Oracle',...

'URL',['jdbc:oracle:thin:@(DESCRIPTION = '...

'(ADDRESS = (PROTOCOL = TCP)(HOST = sname)'...

'(PORT = 123456)) (CONNECT_DATA = '...

'(SERVER = DEDICATED) (SERVICE_NAME = dbname) ) )']);

Close the database connection conn.

close(conn)