DBMS_LOB Package

oracle United States
  • 17 years ago

    Does anybody know what will SELECT query return while quering an blob column in Oracle table.
    e.g. if i have blob column in table(demo) and execute following query;
          "Select blob from demo"  : this query give me following error
         Column or attribute type can not be displayed by SQL*Plus
     So what will be returned at sql propmt while running a query like this on a lob column.

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Brevity is the soul of wit” - Shakespeare