ORA-28553: pass-through SQL: invalid bind-variable position

Cause : A pass-through SQL function referring to the position of a bind variable in the currently-parsed SQL statement supplied an invalid bind-variable position. Valid values are 1 through n, where n is the number of bind-variable place-holders in the SQL text.

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

Verify that the bind-variable position parameter is in the correct range to represent a place-holder in the SQL text. Confirm that the SQL text uses the correct syntax for a bind-variable place-holder, as required by the non-Oracle system.

update : 20-08-2017
ORA-28553

ORA-28553 - pass-through SQL: invalid bind-variable position
ORA-28553 - pass-through SQL: invalid bind-variable position

  • ora-14154 : only one of STORE IN or clause may be specified
  • ora-00569 : Failed to acquire global enqueue.
  • ora-23450 : flavor already contains object "string"."string"
  • ora-14080 : partition cannot be split along the specified high bound
  • ora-22905 : cannot access rows from a non-nested table item
  • ora-22856 : cannot add columns to object tables
  • ora-01234 : cannot end backup of file string - file is in use or recovery
  • ora-25336 : Cannot contact instance string during Streams AQ operation
  • ora-22898 : existing scope clause on "string" points to a table other than the one mentioned in the referential constraint
  • ora-36392 : (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must supply an AGGMAP.
  • ora-28173 : certificate not provided by proxy
  • ora-00376 : file string cannot be read at this time
  • ora-07452 : specified resource manager plan does not exist in the data dictionary
  • ora-24310 : length specified for null connect string
  • ora-02095 : specified initialization parameter cannot be modified
  • ora-29657 : class defined in EXTERNAL NAME clause is used in another subtype
  • ora-01616 : instance string (thread string) is open - cannot disable
  • ora-32056 : invalid number of extents
  • ora-30102 : 'string' is not in the legal range for 'string'
  • ora-39710 : only connect AS SYSDBA is allowed when OPEN in UPGRADE mode
  • ora-01898 : too many precision specifiers
  • ora-15061 : ASM operation not supported [string]
  • ora-25280 : complete sender information not provided to non-repudiate sender
  • ora-06562 : type of out argument must match type of column or bind variable
  • ora-14066 : illegal option for a non-partitioned index-organized table
  • ora-00489 : ARB* process terminated with error
  • ora-01325 : archive log mode must be enabled to build into the logstream
  • ora-25452 : duplicate attribute value for variable: string, attribute: string
  • ora-00355 : change numbers out of order
  • ora-25221 : enqueue failed, signature specified queue not supporting non-repudiation
  • 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.