Re: Error when calling Package/Procedure that Inserts a row
- From: "fitzjarrell@xxxxxxx" <fitzjarrell@xxxxxxx>
- Date: 31 Aug 2006 08:36:10 -0700
CJM wrote:
I'm trying to call a procedure within a package, which inserts a row into a
table.
However, I'm getting the following error:
"SQL execution error, ORA-06550: line 1, column 22: PLS-00302: component
'ADDSERIALTOCATALOG' must be declared ORA-06550: line 1, column 7: PL/SQL:
Statement ignored"
I've searched the web, and the only hints I have found so far are that it
may be a permissions issue. I've checked the object permissions for this
user in OEM and the user does specifically have INSERT privileges for the
table in question.
I've tried using the SQL in the package to insert a record directly through
SQL Developer (using sample data) and it works fine. So one would assume
that a) the syntax correct and b) that the User has sufficient privileges to
insert rows into this table.
Any ideas what else could be causing this?
Thanks in advance.
CJM
Without seeing your actual code used to call this procedure it's
difficult to say, however I expect from the error message that you're
*not* prefixing the procedure with the package name.
Post at least the 'snippet' causing the problems and further assistance
can be provided.
David Fitzjarrell
.
- Follow-Ups:
- References:
- Prev by Date: Error when calling Package/Procedure that Inserts a row
- Next by Date: Re: Oracle XE and the databases
- Previous by thread: Error when calling Package/Procedure that Inserts a row
- Next by thread: Re: Error when calling Package/Procedure that Inserts a row
- Index(es):
Relevant Pages
|
