Home » Developer & Programmer » Forms » ORA-04067 when calling fmx (Oracle Application Server 10g Release 2)
icon8.gif  ORA-04067 when calling fmx [message #348564] Wed, 17 September 2008 05:02 Go to next message
alex1982
Messages: 4
Registered: September 2008
Junior Member
Hello, everybody

I have transfered my oracle application server from Windows to Unix lately.
I have installed Oracle Application Server 10g Release 2
10.1.2.0.2 on HP-UNIX Itanium B11.23.
Installation went succesfully and also forms compiled successfully.
When i try to execute one form it displays the error

ORA-04067 not executed,stored procedure PUBLIC not found.

It doesn't recognize a procedure inside a package in the database.

The procedure takes as parameter a TYPE parameter
TYPE TBL_VARCHAR2 IS TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;

This is the only difference between this procedure and other procedures that are recognized at runtime.

Any help would be appreciated
Re: ORA-04067 when calling fmx [message #348569 is a reply to message #348564] Wed, 17 September 2008 05:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-04067: not executed, %s does not exist
 *Cause:  Attempt to execute a non-existent stored procedure.
 *Action: Make sure that a correct name is given.

Regards
Michel
Re: ORA-04067 when calling fmx [message #348572 is a reply to message #348569] Wed, 17 September 2008 05:23 Go to previous messageGo to next message
alex1982
Messages: 4
Registered: September 2008
Junior Member
Yes , i have already checked.The procedure exists and everything is correct, regarding the name.
Re: ORA-04067 when calling fmx [message #348789 is a reply to message #348564] Wed, 17 September 2008 23:39 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Do not use the name 'public' for your own code. Rename it and try again.

David
Previous Topic: procedure based data block
Next Topic: fetching value from a dynamic query in forms10g
Goto Forum:
  


Current Time: Thu Dec 08 16:28:09 CST 2016

Total time taken to generate the page: 0.20579 seconds