|
DBMS_LOB.COMPARE |
N/A |
N/A |
ORALOB.Compare |
Use DBMS_LOB.COMPARE |
|
DBMS_LOB.INSTR |
N/A |
N/A |
ORALOB.Matchpos |
position |
|
DBMS_LOB.SUBSTR |
N/A |
N/A |
N/A |
getBytes for BLOBs or BFILEs
getSubString for CLOBs |
|
DBMS_LOB.APPEND |
OCILobAppend |
APPEND |
ORALOB.Append |
Use length and then putBytes or PutString |
|
N/A [use Pl/SQL assign operator] |
OCILobAssign |
ASSIGN |
ORALOB.Clone |
N/A [use equal sign] |
|
N/A |
OCILobCharSetForm |
N/A |
N/A |
N/A |
|
N/A |
OCILobCharSetId |
N/A |
N/A |
N/A |
|
DBMS_LOB.CLOSE |
OCILobClose |
CLOSE |
N/A |
use DBMS_LOB.CLOSE |
|
DBMS_LOB.COPY |
OCILobCopy |
COPY |
ORALOB.Copy |
Use read and write |
|
N/A |
OCILobDisableBuffering |
DISABLE BUFFERING |
ORALOB.
DisableBuffering |
N/A |
|
N/A |
OCILobEnableBuffering |
ENABLE BUFFERING |
ORALOB.
EnableBuffering |
N/A |
|
DBMS_LOB.ERASE |
OCILobErase |
ERASE |
ORALOB.Erase |
Use DBMS_LOB.ERASE |
|
DBMS_LOB.FILECLOSE |
OCILobFileClose |
CLOSE |
ORABFILE.Close |
closeFile |
|
DBMS_LOB.FILECLOSEALL |
OCILobFileCloseAll |
FILE CLOSE ALL |
ORABFILE.CloseAll |
Use DBMS_LOB.FILECLOSEALL |
|
DBMS_LOB.FILEEXISTS |
OCILobFileExists |
DESCRIBE [FILEEXISTS] |
ORABFILE.Exist |
fileExists |
|
DBMS_LOB.GETCHUNKSIZE |
OCILobGetChunkSize |
DESCRIBE [CHUNKSIZE] |
N/A |
getChunkSize |
|
DBMS_LOB.FILEGETNAME |
OCILobFileGetName |
DESCRIBE [DIRECTORY, FILENAME] |
ORABFILE.
DirectoryName
ORABFILE.
FileName |
getDirAlias
getName |
|
DBMS_LOB.FILEISOPEN |
OCILobFileIsOpen |
DESCRIBE [ISOPEN] |
ORABFILE.IsOpen |
Use DBMS_LOB.ISOPEN |
|
DBMS_LOB.FILEOPEN |
OCILobFileOpen |
OPEN |
ORABFILE.Open |
openFile |
|
N/A (use BFILENAME operator) |
OCILobFileSetName |
FILE SET |
DirectoryName
FileName |
Use BFILENAME |
|
N/A |
OCILobFlushBuffer |
FLUSH BUFFER |
ORALOB.FlushBuffer |
N/A |
|
DBMS_LOB.GETLENGTH |
OCILobGetLength |
DESCRIBE [LENGTH] |
ORALOB.Size |
length |
|
N/A |
OCILobIsEqual |
N/A |
N/A |
equals |
|
DBMS_LOB.ISOPEN |
OCILobIsOpen |
DESCRIBE [ISOPEN] |
ORALOB.IsOpen |
use DBMS_LOB.ISOPEN |
|
DBMS_LOB.LOADFROMFILE |
OCILobLoadFromFile |
LOAD FROM FILE |
ORALOB.
CopyFromBfile |
Use read and then write |
|
N/A [always initialize] |
OCILobLocatorIsInit |
N/A |
N/A |
N/A |
|
DBMS_LOB.OPEN |
OCILobOpen |
OPEN |
ORALOB.open |
Use DBMS_LOB.OPEN |
|
DBMS_LOB.READ |
OCILobRead |
READ |
ORALOB.Read |
BLOB or BFILE: getBytes and getBinaryStream
CLOB: getString and getSubString and getCharacterStream |
|
DBMS_LOB.TRIM |
OCILobTrim |
TRIM |
ORALOB.Trim |
Use DBMS_LOB.TRIM |
|
DBMS_LOB.WRITE |
OCILobWrite |
WRITEORALOB. |
ORALOB.Write |
BLOB or BFILE: putBytes and getBinaryOutputStream
CLOB: putString and getCharacterOutputStream |
|
DBMS_LOB.WRITEAPPEND |
OCILobWriteAppend
|
WRITE APPEND |
N/A
|
Use length and then putString or putBytes
|
|
DBMS_LOB.
CREATETEMPORARY |
OCILobCreateTemporary |
|
N/A
|
|
|
DBMS_LOB.
FREETEMPORARY |
OCILobFree Temporary |
|
N/A
|
|
|
DBMS_LOB.ISTEMPORARY |
OCILobIsTemporary
|
|
N/A
|
|
|
|
OCILobLocatorAssign |
|
N/A |
|
