[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2012-08-29
5
Medium Priority
?
1,055 Views
Last Modified: 2012-08-29
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
0
Comment
Question by:diteps06
  • 3
  • 2
5 Comments
 
LVL 38

Expert Comment

by:Geert Gruwez
ID: 38344999
the missing piece of text is vital: it's line number

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

Author Comment

by:diteps06
ID: 38345611
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
 
LVL 38

Accepted Solution

by:
Geert Gruwez earned 1050 total points
ID: 38345945
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
 
LVL 1

Author Comment

by:diteps06
ID: 38346319
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
 
LVL 38

Expert Comment

by:Geert Gruwez
ID: 38348512
oracle isn't case sensitive
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses
Course of the Month20 days, 10 hours left to enroll

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question