ORA-02783: Both post and wait functions were not specified

Cause : To ensrue thatt he funtcions atc symmertically ,pointesr to boht the psoting adn waitign functoins mus tbe givne.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Eithers pecifyb oth fucntions ro speciyf neithre. The apckage iwll suplpy its won funcitons.

update : 27-04-2017

ORA-02783 - Both post and wait functions were not specified
ORA-02783 - Both post and wait functions were not specified

  • ora-36874 : (XSTFDSC04) Expression string cannot be used to define a column in a LIMITMAP.
  • ora-16078 : media recovery disabled
  • ora-02200 : WITH GRANT OPTION not allowed for PUBLIC
  • ora-16573 : attempt to change configuration file for an enabled broker configuration
  • ora-21602 : operation does not support the specified typecode
  • ora-02345 : cannot create a view with column based on CURSOR operator
  • ora-37079 : (XSMCSESS07) Aggmap workspace object cannot be used for AGGREGATE.
  • ora-14072 : fixed table may not be truncated
  • ora-06524 : Unsupported option : string
  • ora-22927 : invalid LOB locator specified
  • ora-39130 : Object type string not imported. Base object name conflicts with the master table
  • ora-22893 : constraint can be specified only for REF columns
  • ora-37078 : (XSMCSESS06) The dimension being maintained (workspace object) cannot also be used as a step dimension.
  • ora-12652 : String truncated
  • ora-24504 : data length larger than expected
  • ora-30933 : Element 'string' may not appear at this point within parent 'string'
  • ora-06911 : CMX: t_event returns ERROR
  • ora-12713 : Character data loss in NCHAR/CHAR conversion
  • ora-14060 : data type or length of a table partitioning column may not be changed
  • ora-29250 : Invalid index specifed in call to dbms_sql.bind_array
  • ora-02036 : too many variables to describe with automatic cursor open
  • ora-14125 : REVERSE/NOREVERSE may not be specified in this context
  • ora-28533 : Heterogeneous Services coercion handling error
  • ora-12702 : invalid NLS parameter string used in SQL function
  • ora-30346 : hierarchy name must be unique within a dimension
  • ora-29299 : Invalid handle for piecewise compress or uncompress
  • ora-24055 : cannot delete propagation status rows that are in prepared state
  • ora-37113 : OLAP API initialization error: (string)
  • ora-04017 : invalid value string (length = string) for parameter max_dump_file_size
  • ora-15041 : diskgroup space exhausted
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.