code_junkie

How can I use a database server from a Perl CGI script?

Nov 12th, 2011
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. BEGIN {
  2. $ENV{ORACLE_HOME} = '/home/oracle/product/10.x.x';
  3. $ENV{TWO_TASK} = 'DB';
  4. }
  5. $dbh = DBI->connect('dbi:Oracle:','scott', 'tiger');
  6. # - or -
  7. $dbh = DBI->connect('dbi:Oracle:','scott/tiger');
  8.  
  9. my $db = DBI->connect("dbi:Oracle:host=$host;sid=$database", $user, $pass,
  10. { RaiseError => 0, PrintError => 0 } )
  11. or croak( "Unable to connect to DB - $DBI::errstr" );
Add Comment
Please, Sign In to add comment