Wednesday, December 4, 2013

Oracle iStore Catalogs are Not Displaying Prices after Patch

11.5.10/12: Oracle iStore Catalogs are Not Displaying Prices after Patch:8875985 (11i) or
Patch:9592589 (R12) [ID 1203984.1]
select owner, type_name,instantiable from all_types where type_name='NUMBERTABLE';
SELECT OBJECT_NAME, OBJECT_TYPE, OWNER, STATUS FROM DBA_OBJECTS
WHERE OBJECT_NAME='NUMBERTABLE';
create or replace type NUMBERTABLE as table of NUMBER;

Check………………..


1 comment: