1 2 Previous Next 25 Replies Latest reply: Feb 20, 2014 8:44 AM by Mike Kutz Go to original post RSS
      • 15. Re: How to read a blob field
        BluShadow

        How was the character data inserted into the BLOB in the first place?  (And why on Earth was it not stored in a CLOB like it should have been?)

        • 16. Re: How to read a blob field
          949239

          Hi odie_63,

          I don't know, how it's been encoded in the first place.

          how can I get the raw hexadecimal sequence?

          Thanks for your help.

          • 17. Re: How to read a blob field
            949239

            Hi BluShadow ,

            I don't know how it's getting inserted as the insertion is done through application.

            But I could see in the database that it's a BLOB field.

            Thanks.

            • 18. Re: How to read a blob field
              padders

              What is the output of...

               

              1. DBMS_LOB.SUBSTR (blob_field)

              2. utl_i18n.raw_to_char (blob_field, 'AL16UTF16')

              • 19. Re: How to read a blob field
                odie_63

                I don't know, how it's been encoded in the first place.

                But you're expecting us to know, aren't you?

                Well, at least we can try to infer the encoding scheme by looking at the raw byte sequence (see below).

                 

                how can I get the raw hexadecimal sequence?

                You already know that (from your first post) : DBMS_LOB.substr

                See Padder's reply as well.


                • 20. Re: How to read a blob field
                  949239

                  Hi Padders,

                  Thanks for your reply.

                  Please find the out put below:

                  1. DBMS_LOB.SUBSTR (blob_field):  000000000000163E000000000000203E00000000000039C0000000000000F8FF000000000000F8FF000000000000F8FF000000000000163E000000000000203E00000000006DB64000 0000000000F8FF000000000000F8FF000000000000F8FF

                   

                  2. utl_i18n.raw_to_char (blob_field, 'AL16UTF16') :

                  ¿   ¿   ¿   ¿   ¿   ¿   ¿   ¿  m¿   ¿   ¿   ¿

                   

                  Thanks for your time.

                  • 21. Re: How to read a blob field
                    949239

                    Hi Odie_63,

                    Sorry for the misunderstanding.I never meant that :-) What I was trying the say is I am also not aware as the data is inserted from the application.

                    Thanks for your support.

                    • 22. Re: How to read a blob field
                      odie_63

                      So what is that sequence supposed to represent in readable form?

                      Is it this ?

                      593.70  10.00  25.00  0.00  0.00

                      • 23. Re: How to read a blob field
                        949239

                        Hi Odie_63,

                        Sorry, I couldn't provide you corresponding data.

                        The one which I have given you previously is already deleted from the db.

                        The hexadecimal sequence which I have given you just before should be as below in the readable form:

                         

                        681056.72   7128136.74     25.00  0.00     0.000.790.000.000.000.000.000.00     0.00
                        681056.72   7128136.74  -5741.00  5766.00  0.000.790.000.000.000.000.005766.000.00

                         

                        Thanks for your reply.

                        • 24. Re: How to read a blob field
                          BluShadow

                          There's no way that that hex string represents all those numbers.  At best, for numeric values exceeding 255, you'd be looking at that string providing 16 non-zero values... if you split it every 16 bytes.

                           

                          000000000000163E

                          000000000000203E

                          00000000000039C0

                          000000000000F8FF

                          000000000000F8FF

                          000000000000F8FF

                          000000000000163E

                          000000000000203E

                          00000000006DB640

                          000000000000F8FF

                          000000000000F8FF

                          000000000000F8FF

                           

                          You need to post us a hex string and a known corresponding result.

                          • 25. Re: How to read a blob field
                            Mike Kutz

                            Curious:  Are you and 936666 working on the same project?

                            I'm going to tell you the same thing I told him:  Re: Java pl sql vs pl sql

                             

                            If the data is suppose to be in a table format, then the application needs to be modified to provide you with the correct INSERT statements... not BLOB data.

                             

                            I would parse through that thread and the other one I link to in there. (and a few others from 936666)

                            You might find some interesting answers.

                             

                            MK

                            1 2 Previous Next