Error executing sql statement from perl

Hi All,
My env:
TS 6.5
oracle 9i

I have following statements in my perl file..

my $stmt = $dbh->prepare($sql);
$stmt->execute();
$stmt->finish();

but when I run this IPL it throws me this error:

PL/SQL: SQL Statement ignored (DBD ERROR: error possibly near <*> indicator at char in BEGIN\n

Doesnt look like oracle error since if I take the $sql and run it via sqlplus it runs it very well..

any comments?
Thx in advance...
JM

Find more posts tagged with

Comments

jbonifaci

Can you please post the remainder of the script? It will help others help you.

motlnt

here is the complete code..

the sql execute() is somewhere around line 659...
i will post the log file also.

thx
JM

motlnt

here is what log file says...

JM

jbonifaci

Do you have the exact SQL statement that is being generated by your perl script? Can you output it to a log prior to execution?

motlnt

Hi all,
I have fixed this.
It was failing at database level due to some already present lock.
Thx anyways..
JM