very iritating oracle error
-
what exactly is it iam not so sure, when ever i try to insert values from an asp page, it throws me this error.
its just a simple table ,a package and a stored procedure in that package
what could be this, and what can be the solution
----------Error is--------
Microsoft OLE DB Provider for Oracle error '80004005'
ORA-04068: existing state of packages has been discarded ORA-04063: has errors ORA-04063: package body "SYS.TOOLKIT" has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 1 ORA-06512: at "IPTS.IPTS_MTN_PKG_INS_COMPANY", line 32 ORA-06512: at line 1
/IPTS-Site/MTN_MASTER/InsurancecompanyAdd.asp, line 317
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
-
Try to recompile the package in Oracle. If you're using a tool like TOAD, you can easily see the compile state of the package. Then, look inside the package to make sure that you're calling a function in it!
Your user account may not have execute privs on the package/function if it's in another schema. Unfortunately, your user account has to be granted execute privs on the table, not granted to any roles your user is a member of *
Post the sql you're trying to execute...
-
thanks, but that problem is solved,
ya it was i had to recompile, but then the problem was in the encryption table was blank
i just needed to add the encryption key, as it was blank it was throwing null value
<a href="http://www.websolsoftware.com"> For IT jobs click here</a>
*Sukhoi*[font="Arial Narrow"][/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply