Hi,

You need to export some variables for Oracle

export ORACLE_HOME=/home/foo/oracle/client_1
export LD_LIBRARY_PATH=$ORACLE_HOME/product/oracle_version/client_1/lib/

ORACLE_SID is the name of the instance.

export ORACLE_SID=ORCL

After you can try this code:

use strict;
use warnings;
use DBI;

my $host = '192.168.0.1';
my $driver = 'Oracle';
my $database = 'ORCL';
my $username = 'USER';
my $password = 'PASS';
my $dbh = DBI->connect("dbi:Oracle:host=$host;sid=$database", $usernam
+e, $password, {RaiseError => 1, AutoCommit => 0});
[download]

If they work without error, now you can try: myapp_create.pl model ....

Good luck!

PS: you can use ENV instead export at Perl:

BEGIN {$ENV{ORACLE_HOME} = '/home/foo/oracle/product/oracle_version/cl
+ient_1/';}
[download]