ORA-36802: (XSTBLFUNC01) The OLAP_TABLE function must
contain a DATAMAP that executes a FETCH command or a LIMITMAP.



ORA-36802: (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH comma..

Answer / guest

Cause: There is no limitmap on the table function and either
the datamap does not contain a fetch, or it errored before
the fetch was called.

Action: Check the datamap for errors, make sure that it
executes a fetch statement, if it is not intended to execute
the fetch then make sure that the table function has a valid
limitmap.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-38446: Error with embedded ADT "string" in the attribute set.

1 Answers  


ORA-30565: Only one INVALIDATE or UPDATE GLOBAL INDEXES clause may be specified

1 Answers  


ORA-29379: resource plan string is involved in a loop in top-plan string

1 Answers  


ORA-01570: MINEXTENTS must be no larger than the string extents currently allocated

1 Answers  


ORA-22921: length of input buffer is smaller than amount requested

1 Answers  






ORA-12840: cannot access a remote table after parallel/insert direct load txn

1 Answers  


DGM-16903: Unable to connect to database

1 Answers  


DRG-11443: gist maxPercent string is invalid

1 Answers  


ORA-09818: Number is too large

1 Answers  


ORA-08189: cannot flashback the table because row movement is not enabled

2 Answers  


ORA-08120: Need to create SYS.IND_ONLINE$ table in order to (re)build index

1 Answers  


ORA-12412: policy package string is not installed

1 Answers  


Categories