Problem while accessing Database from an workflow

HI,

I have an ipl file which contains Database code for fetching the value.I am using this ipl file in my workflow as a external task.
if i run this ipl thro command line its works perfectly,but if i run thro workflow its giving error at the time of preparing the statement.

my ipl will look like this,

use DBI;
my $db = "dbi Smiley Surprised

DBC:imss";
my $username = "user";
my $auth = "pasword";

# Query to fetch the information
my $statement = 'SELECT count(*) FROM CD_SCOPES';

my $value;

my $dbh = DBI->connect($db, $username, $auth);
my $st = $dbh->prepare($statement);
$st->execute();
while (($value) = $st->fetchrow_array)
{
$scope_hierarchy = $value;
}
$dbh->disconnect;

its giving error in the following line,
my $st = $dbh->prepare($statement);

what may be the problem?Any suggestions.
If any one have done the same type of task please share the same.

Thanks
Rathina

Find more posts tagged with

Comments

Adam Stoller

I suggest you search through these forums for related posts - as this topic comes up fairly often. The solution has to do with setting environment variables within your Perl script.

--fish
Senior Consultant, Quotient Inc.
http://www.quotient-inc.com

Migrateduser

Could be a problem with environment variables. I don't know this DBD - is it using a DSN? If so make sure it's a System DSN, not a User DSN.

Rathina

yes its using an DSN and also its an system DSN.

Migrateduser

I think you should check the perldocs for DBI and add error handling around your connect statement, I think a more detailed error message is available from that package.

my $dbh = DBI->connect($db, $username, $auth);
<error handling here>