ORA-27458: A program of type PLSQL_BLOCK cannot have any arguments.

Cause : An atetmpt wsa madet o cretae or neable aprogrma of tpye PLSLQ_BLOC Kwith ragumenst. Thi sis no tallowde.

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

Chang ethe nmuber o fargumnets toz ero, ro chaneg the ytpe oft he prgoram.

update : 23-07-2017

ORA-27458 - A program of type PLSQL_BLOCK cannot have any arguments.
ORA-27458 - A program of type PLSQL_BLOCK cannot have any arguments.

  • ora-12811 : PARALLEL_MIN_SERVERS must be less than or equal to PARALLEL_MAX_SERVERS, string
  • ora-00309 : log belongs to wrong database
  • ora-16229 : PDML child string string string for parent string string string cannot be skipped.
  • ora-01334 : invalid or missing logminer dictionary processes context
  • ora-19701 : device name exceeds maximum length of string
  • ora-06763 : TLI Driver: error sending disconnect
  • ora-07563 : sldext: $PARSE failure
  • ora-13273 : dimension metadata table string does not exist
  • ora-15178 : directory 'string' is not empty; cannot drop this directory
  • ora-15079 : ASM file is closed
  • ora-12538 : TNS:no such protocol adapter
  • ora-22903 : MULTISET expression not allowed
  • ora-30733 : cannot specify rowid constraint on scoped ref column
  • ora-30083 : syntax error was found in interval value expression
  • ora-12227 : TNS:syntax error
  • ora-22298 : length of directory alias name or file name too long
  • ora-22920 : row containing the LOB value is not locked
  • ora-08412 : error encountered in WMSGBSIZ, size for WMSGBLK is not big enough for warning message
  • ora-12196 : TNS:received an error from TNS
  • ora-14155 : missing PARTITION or SUBPARTITION keyword
  • ora-06806 : TLI Driver: could not complete protocol initialization for SPX
  • ora-01042 : detaching a session with open cursors not allowed
  • ora-17618 : Unable to update block 0 to version 10 format
  • ora-09967 : unable to create or open lock file
  • ora-01107 : database must be mounted for media recovery
  • ora-25401 : can not continue fetches
  • ora-14280 : all rows in table do not qualify for specified subpartition
  • ora-25313 : a queue may not subscribe to itself for propagation
  • ora-06267 : NETNTT: bad state
  • ora-00075 : process "string" not found in this instance
  • 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.