Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Error when calling Package/Procedure that Inserts a row

Error when calling Package/Procedure that Inserts a row

From: CJM <cjmnews04_at_REMOVEMEyahoo.co.uk>
Date: Thu, 31 Aug 2006 16:18:46 +0100
Message-ID: <4loculF2tjdhU1@individual.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US