Re: Error when calling Package/Procedure that Inserts a row

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 Received on Thu Aug 31 2006 - 10:36:10 CDT