ORA-06579: Bind variable not big enough to hold the output value

Cause : The bind variable specified by the user is not large enough to hold the output returned by the function or a procedure.

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

Specify a bind variable of larger size.

update : 17-08-2017
ORA-06579

ORA-06579 - Bind variable not big enough to hold the output value
ORA-06579 - Bind variable not big enough to hold the output value

  • ora-38446 : Error with embedded ADT "string" in the attribute set.
  • ora-16134 : invalid MANAGED recovery FINISH option
  • ora-29814 : expecting USING or DEFAULT keyword
  • ora-28055 : the password will expire within string days
  • ora-01725 : USERENV('COMMITSCN') not allowed here
  • ora-00231 : snapshot control file has not been named
  • ora-14611 : Duplicate subpartition name string in template
  • ora-30649 : missing DIRECTORY keyword
  • ora-13192 : failed to read number of element rows
  • ora-34840 : (OPCREATE01) The string option must be declared with datatype string.
  • ora-28530 : Heterogeneous Services initialization error in NLS language ID
  • ora-24908 : invalid recipient presentation attribute
  • ora-00252 : log string of thread string is empty, cannot archive
  • ora-06904 : CMX: no transport address available for remote application
  • ora-28100 : policy function schema string is invalid
  • ora-14303 : partitions or subpartitions are not in the right order
  • ora-15000 : command disallowed by current instance type
  • ora-36223 : (XSLPDSC04) object workspace object in IGNORE or DENSE list has illegal type
  • ora-19376 : no privileges on tablespace provided or tablespace is offline
  • ora-39003 : unable to get count of total workers alive
  • ora-40214 : duplicate setting: string
  • ora-09812 : Unable to get user clearance from connection
  • ora-01528 : EOF while processing SQL statement
  • ora-23440 : incorrect public template value
  • ora-12719 : operation requires database is in RESTRICTED mode
  • ora-13005 : recursive HHCODE function error
  • ora-26737 : version string already has an export dump file
  • ora-00741 : logfile size of (string) blocks exceeds maximum logfile size
  • ora-25303 : Buffered operation allowed only on the owner instance
  • ora-30028 : Automatic Undo Management event for NTP testing
  • 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.