develooper Front page | perl.beginners | Postings from December 2002

RE: migrating to oracle from mysql

Thread Previous
Bob Showalter
December 27, 2002 05:45
RE: migrating to oracle from mysql
Message ID:
> -----Original Message-----
> From: Ramprasad []
> Sent: Friday, December 27, 2002 1:00 AM
> To:
> Subject: migrating to oracle from mysql
> Hello all ,
>     I have been using mysql as a database and helped 
> me do most 
> of the work easily. Now If my database changes to oracle ( which it 
> probably would ) then will I have to rewrite all the code.
>    I just looked at DBI and found them to be too much of a 
> bother using 
> such a module. I am required to do *prepare* , *bind_param* , 
> *execute* 
> , *bind_column* etc just to get a simple sql select statement with a 
> where clause.

No, not true. This will return a set of rows in one statement:

   my $aref = $dbh->selectall_arrayref("select * from foo where bar='baz'");

>     Are there any simpler interfaces to oracle

Use DBI. If you had been using DBI all along, your port to Oracle would be
much easier.

Consider also Class::DBI. See:>

Thread Previous Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at | Group listing | About