Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


PCB-00230: Indicator table size must not be less than its
host variable



PCB-00230: Indicator table size must not be less than its host variable..

Answer / guest

Cause: An host variable table was used with an indicator
table declared with a smaller dimension. For example: EXEC
SQL BEGIN DECLARE SECTION END-EXEC. 01 EMP-NUM OCCURS 4
TIMES PIC S9(4) COMP. 01 EMP-NUM-IND OCCURS 2 TIMES PIC
S9(4) COMP. EXEC SQL END DECLARE SECTION END-EXEC. ...
SELECT ... INTO EMP-NUM:EMP-NUM-IND ...

Action: Increase the size of the indicator table.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01312: Specified table/column does not exist

1 Answers  


ORA-24084: DBLINK name in address field of agent string is not unique within the first 24 bytes

1 Answers  


QSM-01022: a more optimal materialized view than string was used to rewrite

1 Answers  


RMAN-06489: no configuration found to allocate clone channel number for device type string

1 Answers  


ORA-12426: invalid audit option

1 Answers  


ORA-19628: invalid SCN range

1 Answers  


ORA-14117: partition resides in offlined tablespace

1 Answers  


ORA-02219: invalid NEXT storage option value

1 Answers  


ORA-31663: metadata remap name can not be defaulted

1 Answers  


TNS-12593: TNS:no registered connection

1 Answers  


CLSR-00524: Resource string is stopping, resource string cannot start

1 Answers  


ORA-01115: IO error reading block from file string (block # string)

1 Answers  


Categories