how to print the names of tables of database using perl scripting using unix

Question

How to print the names of tables of database using Perl scripting using unix. Connected to DB using DBI module.

I tried scripting using

     my $driver= "Oracle";
     my $dsn = "DBI:$driver:sid=as;host=asdsa";
     my $dbh = DBI->connect($dsn, "a", "b") || die( $DBI::errstr . "\n" );
     my $notables = $dbh->tables();
     print "No of tables : $notables" ;

Getting error:

Can't call method "tables" on an undefined value at hello.pl line 16.

Please help.

Your $dbh object is undefined. Are you sure you connected to the database? Pleae edit your question and include the part that does my $dbh = DBI->connect. Or better, include the full program. Also take a look at How to Ask to learn how to format code in your question. — simbabque
– simbabque, Commented Sep 29, 2017 at 9:02
Is this really the code that produces this error? It seems unlikely to me. A call to connect() will return either a database handle or undef. Returning undef would trigger your die() call, so you must be getting a defined database handle back from connect(). I suspect there is something else going in parts of the code that you have removed to simplify your example. — Dave Cross
– Dave Cross, Commented Sep 29, 2017 at 12:50

ilux · Accepted Answer · 2017-09-29 09:08:43Z

1

Looks like you not connected to DB.

Read DBI documentation and try something like this:

use DBI;
use Data::Dumper;

my $dbh = DBI->connect($data_source, $username, $password)
          or die $DBI::errstr;

my @names = $dbh->tables( $catalog, $schema, $table, $type );
print Dumper @names;

$dbh->tables; without args is deprecated

answered Sep 29, 2017 at 9:08

ilux

3674 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to print the names of tables of database using perl scripting using unix

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related