On Wednesday 18 August 2004 17:31, Danny Lieberman (Barak) wrote:
> Noam
>
>
> Install DBI frpm Cpan
> use it like any other module i.e. use DBI;
> DBI doesnt do much by itself, you need to specify a db driver,the database
> driver for Oracle is called DBD::Oracle
>
> For example to do a SELECT (i'm assuming you know SQL if not - there are a
> ton of SQL tutorials out there)
>
> use DBI;
>
> my $user = 'noam';
> my $pass = '';
> my $dbh = DBI->connect("DBI::Oracle:dbname="beyond",$user,$passw ) ||
> die "Error connecting: '$DBI:errstr'";
>
> # create query
> my $sql = "SELECT ....";
>
> # prepare the stmt
> my $stm = $dbh->prepare($sql) ||
> die "Error preparing: '$DBI:errstr'";
>
> # Execute
> my $stm = $stm->execute ||
> die "Error preparing: '$DBI:errstr'";
>
> # Run thru the rows of the record set
> while (my $row = $stm->fetchrow_arrayref)
> {
> my ($field1, $field2 etc...) = @{$rowref}
> ....etc...
> }
>
>
> Rgrds
>
>
> Danny Lieberman
> Open Solutions Israel
> +972-8-970-1485(voice)
> +972-54-471114(Cell)
> www.opensolutions.co.il
>
Hi,Thank you for the effort explain that, I already tried DBI::Oracle, but I am missing as Muli stated one essential part :) an Oracle Client :) -- Thanks Noam Rathaus CTO Beyond Security Ltd. Join the SecuriTeam community on Orkut: http://www.orkut.com/Community.aspx?cmm=44441 ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
