asked on

Perl script that calls oracle procedure goes in error “Statement ignored (DBD ERROR"

I have a perl script which calls an oracle procedure produces the following error :
Statement ignored (DBD ERROR: error possibly near <*> indicator at char 10 in '

The procedure is define as follows:

DECLARE
       n INTEGER;
      BEGIN
       Proc1('inp',n);
      END;

The perl is launched in a unix environment

Geert G

the missing piece of text is vital: it's line number

error possibly near <*> indicator at char 10 in '..... missing text here ....

diteps06

ASKER

Statement ignored (DBD ERROR: error possibly near <*> indicator at char 10 in '

Before the above there is the following present:
"DBD::Oracle::db do failed: ORA-06550: line 8, column 27:
PLS-00201: identifier 'PKG_SD.T_LIST_COL' must be declared"

However, T_LIST_COL is define in the package

The complete error is:
DBD::Oracle::db do failed: ORA-06550: line 8, column 27:
PLS-00201: identifier 'PKG_SD.T_LIST_COL' must be declared
ORA-06550: line 6, column 4:
PL/SQL: Statement ignored (DBD ERROR: error possibly near <*> indicator at char 10 in '

It seems the problem is link to the grant of the user on the package

ASKER CERTIFIED SOLUTION

Geert G

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

diteps06

ASKER

Running the query suggested the user 'sees' the package.
It seems the problem was due to a case sensitive issue on the procedure name.

It now functions.

Geert G

oracle isn't case sensitive

Perl script that calls oracle procedure goes in error “Statement ignored (DBD ERROR&quot;

Perl script that calls oracle procedure goes in error “Statement ignored (DBD ERROR"