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
LVL 1
diteps06Asked:
Who is Participating?
 
Geert GConnect With a Mentor Oracle dbaCommented:
it does look like the user can't *see* the package

login with the user
and run this sql to see if you can *see* the package:

select * from all_source
where owner = 'OWNERNAME'
  and name = 'PKG_SD'
  and type='PACKAGE';
0
 
Geert GOracle dbaCommented:
the missing piece of text is vital: it's line number

error possibly near <*> indicator at char 10 in '..... missing text here ....
0
 
diteps06Author Commented:
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
0
 
diteps06Author Commented:
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.
0
 
Geert GOracle dbaCommented:
oracle isn't case sensitive
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.