Home » SQL & PL/SQL » SQL & PL/SQL » Existing state of package... (Merged)
Existing state of package... (Merged) [message #187331] Sat, 12 August 2006 04:17 Go to next message
vamsi_krishna_777
Messages: 7
Registered: August 2006
Location: Mumbai
Junior Member

Hi
i am not able to execute a DBMS_PIPE.SEND_MESSAGE
if i execute this then it giving following erorr
exec :x:=DBMS_PIPE.SEND_MESSAGE ('VAMSI');


*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "AFHHOST.DBMS_PIPE" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1


even for other procedure's in that package it is giving same error.

Is it the problem of privilages
getting existing state of packages has been discarded for DBMS_PIPE [message #187333 is a reply to message #187331] Sat, 12 August 2006 04:28 Go to previous messageGo to next message
vamsi_krishna_777
Messages: 7
Registered: August 2006
Location: Mumbai
Junior Member

getting following erorr for

14:34:22 SQL> exec :x:=DBMS_PIPE.SEND_MESSAGE ('VAMSI');
BEGIN :x:=DBMS_PIPE.SEND_MESSAGE ('VAMSI'); END;

*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "AFHHOST.DBMS_PIPE" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
Re: Existing state of package... (Merged) [message #187346 is a reply to message #187331] Sat, 12 August 2006 08:16 Go to previous messageGo to next message
rabhavani
Messages: 8
Registered: June 2006
Location: HYDERABAD
Junior Member

Hi Vamsi,

First check the status of the Dependent Objects,if dependent objects status is invalid then first make their status to valid and then run

ALTER PACKAGE <Package name> COMPILE;

Note :- Package name is your package name

and then try executing.

Regards,
Bhavani


Re: Existing state of package... (Merged) [message #187347 is a reply to message #187331] Sat, 12 August 2006 08:28 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>ORA-04067: not executed, package body "AFHHOST.DBMS_PIPE" does not exist
Let me guess since your post is sorely lacking in details.
Are you logged in as "AFHHOST"?
Oracle is reporting that AFHHOST does not have a function called DBMS_PIPE; which is most likely true.
If AFHHOST has the necessary privs, it should be able to do the following:
BEGIN :x:= SYS.DBMS_PIPE.SEND_MESSAGE ('VAMSI'); END;

[Updated on: Sat, 12 August 2006 08:28] by Moderator

Report message to a moderator

Re: Existing state of package... (Merged) [message #187349 is a reply to message #187331] Sat, 12 August 2006 08:59 Go to previous messageGo to next message
vamsi_krishna_777
Messages: 7
Registered: August 2006
Location: Mumbai
Junior Member

Hi

It is DBMS_PIPE package not user defiend package
So is it privilage problem

Regards
vamsi krishna
Re: Existing state of package... (Merged) [message #187368 is a reply to message #187349] Sat, 12 August 2006 17:37 Go to previous message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
vamsi_krishna_777 wrote on Sat, 12 August 2006 08:59

It is DBMS_PIPE package not user defiend package
So is it privilage problem

Regards
vamsi krishna

Except that the error message is quite specific about the package owner. Also it is referring to the package body rather than the specification.

Could something like this have happened?

CREATE PACKAGE dbms_pipe
AS
    PROCEDURE testit;
END dbms_pipe;
/

BEGIN
    dbms_pipe.testit;
END;
/

ORA-04067: not executed, package body "WILLIAMR.DBMS_PIPE" does not exist
ORA-06508: PL/SQL: could not find program unit being called

[Updated on: Sat, 12 August 2006 17:39]

Report message to a moderator

Previous Topic: After executing Dbms_pipe package session get blocked
Next Topic: how to find what check conditions are given to which data field of table.
Goto Forum:
  


Current Time: Thu Dec 08 16:21:37 CST 2016

Total time taken to generate the page: 0.15648 seconds