EXEC sysdb.ssma_oracle.UTL_FILE_FOPEN$IMPL 'USER_DIR', '1.txt', 'r', 1024, @outfile OUTPUT EXEC sysdb.ssma_oracle.UTL_FILE_GET_LINE @outfile, @V1 OUTPUT, 32767 PRINT ('V1= ' + isnull(@V1, '')) IF (sysdb.ssma_oracle.UTL_FILE_IS_OPEN(@outfile) <> /* FALSE */ 0) EXEC sysdb.ssma_oracle.UTL_FILE_FCLOSE @outfile END DBMS_UTILITY Package SSMA supports only the GET_TIME function. Oracle function or T Conversion to SQL Server Comment procedure GET_TIME M SELECT CONVERT(NUMERIC(38, 0), (CONVERT(NUMERIC(38, 10), getdate()) * 8640000)) DBMS_SESSION Package SSMA supports only the UNIQUE_SESSION_ID function. Oracle function or T Conversion to SQL Server Comment procedure UNIQUE_SESSION_ID M [sysdb].ssma_oracle.unique_session_id() Return value is different DBMS_PIPE Package SSMA 3.0 does not convert the DBMS_PIPE system package. To emulate it manually, follow these suggestions. The DBMS_PIPE package has the following subprograms: function Create_Pipe() procedure Pack_Message() function Send_Message() function Receive_Message() function Next_Item_Type() procedure Unpck_Message() procedure Remove_Pipe() procedure Purge() procedure Reset_Buffer() function Unique_Session_Name()
EXEC sysdb.ssma_oracle.UTL_FILE_FOPEN$IMPL 'USER_DIR', '1.txt', 'r', 1024, @outfile OUTPUT EXEC sysdb.ssma_oracle.UTL_FILE_GET_LINE @outfile, @V1 OUTPUT, 32767 PRINT ('V1= ' + isnull(@V1, '')) IF (sysdb.ssma_oracle.UTL_FILE_IS_OPEN(@outfile) <> /* FALSE */ 0) EXEC sysdb.ssma_oracle.UTL_FILE_FCLOSE @outfile END DBMS_UTILITY Package SSMA supports only the GET_TIME function. Oracle function or procedure T Conversion to SQL Server Comment GET_TIME M SELECT CONVERT(NUMERIC(38, 0), (CONVERT(NUMERIC(38, 10), getdate()) * 8640000)) DBMS_SESSION Package SSMA supports only the UNIQUE_SESSION_ID function. Oracle function or procedure T Conversion to SQL Server Comment UNIQUE_SESSION_ID M [sysdb].ssma_oracle.unique_session_id() Return value is different DBMS_PIPE Package SSMA 3.0 does not convert the DBMS_PIPE system package. To emulate it manually, follow these suggestions. The DBMS_PIPE package has the following subprograms: function Create_Pipe() procedure Pack_Message() function Send_Message() function Receive_Message() function Next_Item_Type() procedure Unpck_Message() procedure Remove_Pipe() procedure Purge() procedure Reset_Buffer() function Unique_Session_Name()