Why am I getting an ORA-03127 error when getting the LobLength in the Stream sample code?
This is the correct behavior. LONG columns are not ‘fetched’ in-place (aka in-row). They are fetched out of place and exists in the pipe until you read them explicitly. In this case, we got the LobLocator (getBlob()) and then we are trying to get the length of this LOBbeforewe read the LONG column. Since the pipe is not clear we are getting the above exception. The solution would be to complete reading the Long column before you do any operation on the BLOB.
