DBA Data[Home] [Help]

OLAPSYS.OLAPDIMVIEW dependencies on DBMS_OUTPUT

Line 1681: DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Invalid Path');

1677: commit;
1678: EXCEPTION
1679: WHEN UTL_FILE.INVALID_PATH THEN
1680: UTL_FILE.FCLOSE(filehandle);
1681: DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Invalid Path');
1682: WHEN UTL_FILE.INVALID_OPERATION THEN
1683: UTL_FILE.FCLOSE(filehandle);
1684: DBMS_OUTPUT.PUT_LINE('MV not created as only one level in Dimension ');
1685: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

Line 1684: DBMS_OUTPUT.PUT_LINE('MV not created as only one level in Dimension ');

1680: UTL_FILE.FCLOSE(filehandle);
1681: DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Invalid Path');
1682: WHEN UTL_FILE.INVALID_OPERATION THEN
1683: UTL_FILE.FCLOSE(filehandle);
1684: DBMS_OUTPUT.PUT_LINE('MV not created as only one level in Dimension ');
1685: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
1686: UTL_FILE.FCLOSE(filehandle);
1687: DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Invalid File Handle');
1688: WHEN UTL_FILE.WRITE_ERROR THEN

Line 1687: DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Invalid File Handle');

1683: UTL_FILE.FCLOSE(filehandle);
1684: DBMS_OUTPUT.PUT_LINE('MV not created as only one level in Dimension ');
1685: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
1686: UTL_FILE.FCLOSE(filehandle);
1687: DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Invalid File Handle');
1688: WHEN UTL_FILE.WRITE_ERROR THEN
1689: UTL_FILE.FCLOSE(filehandle);
1690: DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Write Error');
1691: WHEN UTL_FILE.INTERNAL_ERROR THEN

Line 1690: DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Write Error');

1686: UTL_FILE.FCLOSE(filehandle);
1687: DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Invalid File Handle');
1688: WHEN UTL_FILE.WRITE_ERROR THEN
1689: UTL_FILE.FCLOSE(filehandle);
1690: DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Write Error');
1691: WHEN UTL_FILE.INTERNAL_ERROR THEN
1692: UTL_FILE.FCLOSE(filehandle);
1693: DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Internal Error');
1694: WHEN others THEN

Line 1693: DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Internal Error');

1689: UTL_FILE.FCLOSE(filehandle);
1690: DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Write Error');
1691: WHEN UTL_FILE.INTERNAL_ERROR THEN
1692: UTL_FILE.FCLOSE(filehandle);
1693: DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Internal Error');
1694: WHEN others THEN
1695: UTL_FILE.FCLOSE(filehandle);
1696: -- RAISE;
1697: END ;

Line 3416: -- DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Invalid Path');

3412: commit;
3413: EXCEPTION
3414: -- WHEN UTL_FILE.INVALID_PATH THEN
3415: -- UTL_FILE.FCLOSE(filehandle);
3416: -- DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Invalid Path');
3417: -- WHEN UTL_FILE.INVALID_OPERATION THEN
3418: -- UTL_FILE.FCLOSE(filehandle);
3419: -- DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Invalid Operation');
3420: -- WHEN UTL_FILE.INVALID_FILEHANDLE THEN

Line 3419: -- DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Invalid Operation');

3415: -- UTL_FILE.FCLOSE(filehandle);
3416: -- DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Invalid Path');
3417: -- WHEN UTL_FILE.INVALID_OPERATION THEN
3418: -- UTL_FILE.FCLOSE(filehandle);
3419: -- DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Invalid Operation');
3420: -- WHEN UTL_FILE.INVALID_FILEHANDLE THEN
3421: -- UTL_FILE.FCLOSE(filehandle);
3422: -- DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Invalid File Handle');
3423: -- WHEN UTL_FILE.WRITE_ERROR THEN

Line 3422: -- DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Invalid File Handle');

3418: -- UTL_FILE.FCLOSE(filehandle);
3419: -- DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Invalid Operation');
3420: -- WHEN UTL_FILE.INVALID_FILEHANDLE THEN
3421: -- UTL_FILE.FCLOSE(filehandle);
3422: -- DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Invalid File Handle');
3423: -- WHEN UTL_FILE.WRITE_ERROR THEN
3424: -- UTL_FILE.FCLOSE(filehandle);
3425: -- DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Write Error');
3426: -- WHEN UTL_FILE.INTERNAL_ERROR THEN

Line 3425: -- DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Write Error');

3421: -- UTL_FILE.FCLOSE(filehandle);
3422: -- DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Invalid File Handle');
3423: -- WHEN UTL_FILE.WRITE_ERROR THEN
3424: -- UTL_FILE.FCLOSE(filehandle);
3425: -- DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Write Error');
3426: -- WHEN UTL_FILE.INTERNAL_ERROR THEN
3427: -- UTL_FILE.FCLOSE(filehandle);
3428: -- DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Internal Error');
3429: WHEN others THEN

Line 3428: -- DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Internal Error');

3424: -- UTL_FILE.FCLOSE(filehandle);
3425: -- DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Write Error');
3426: -- WHEN UTL_FILE.INTERNAL_ERROR THEN
3427: -- UTL_FILE.FCLOSE(filehandle);
3428: -- DBMS_OUTPUT.PUT_LINE('OlapMaterialView.CreateFatMVTable: Internal Error');
3429: WHEN others THEN
3430: -- UTL_FILE.FCLOSE(filehandle);
3431: RAISE;
3432: END ;