Sitemap

Amicuk Programming Answers

Extracting text from BLOB data

-0001-11-30   Views:0

Advertisement

Let me start by saying that I'm flying by the seat of my pants on this and I'm neither a CR expert nor can I write SQL. Short of a little basic back on my old Apple IIe (way back when,) my programming skills are essentially nil. That said, here's wha

Let me start by saying that I'm flying by the seat of my pants on this and I'm neither a CR expert nor can I write SQL. Short of a little basic back on my old Apple IIe (way back when,) my programming skills are essentially nil.
That said, here's what I'm trying to acheive.
I have created a report that uses an ODBC connection to an Oracle database. It works fine, all the tables are properly linked and it delivers a properly functioning report. I now need to extract some text from a BLOB field. I have all the necessary tables added to the report and I've linked them as well. However, when I add an SQL expression and paste in the  SQL string that uses the function, "getprop" to try to extract the necessary text from the BLOB data, I get the error: "missing expression"
I notice that within the SQL Expression editor, the field for the BLOB data is not listed in the table in which it resides, though the non-BLOB fields are listed. That is, when I say: select getprop(sl.blobdata,'confirmCompany'), there is no sl.blobdata field which I believe is the source of the "missing expression" error.
If I create a new blank report and simply paste the SQL in as a command in the Database Expert, it will deliver the expected results. I get the two fields I need. This means the SQL string is fine. But, of course, all the other columns I need are not available. As I mentioned above, I can't write SQL and I have a fully functional  report that has everything except the two columns i want to add from the BLOB field.
However if I go back to my complete report and add the SQL as a command in the Database Expert, it then asks me to link the fields to the other tables already in the report and that just doesn't work.
I apologize for any mucked up terminology and general concept confusing statements I've made above and hope someone will be able to help me out.
Thanks in advance.
~m

The replay answer
Advertisement
So, in this case you might create a subreport that has
"the SQL in as a command in the Database Expert, it will deliver the expected results. I get the two fields I need. This means the SQL string is fine. But, of course, all the other columns I need are not available. As I mentioned above, I can't write SQL and I have a fully functional report that has everything except the two columns i want to add from the BLOB field. "
of course, this will return all the results, every time it gets kicked off, this is why having something to link to is handy.
You can filter the subreport data, based on main report parameters, if that will help.

Go to See the other 5 answers

Extracting text from BLOB data

Category:DefaultRelease time:-0001-11-30Views:130

Let me start by saying that I'm flying by the seat of my pants on this and I'm neither a CR expert nor can I write SQL. Short of a little basic back on my old Apple IIe (way back when,) my programming skills are essentially nil. That said, here's wha[More]

Infoobject change for extracting texts data.

Category:DefaultRelease time:2015-10-11Views:130

Hi BW guys, Here is my requirement. I have one info object 'salesmen', which is already used in some other ODS & Cube's. Now I want to extract texts data for the object 'salesmen', for that I will need to change my infoobject (changes are : adding cr[More]

Append a text line on blob data.

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I need append a text line on blob data. I haven't found prosper example or guide yet. Following is example blob data which i should handle with. Date: Thu, 29 Oct 2009 18:36:56 +0900 (KST) From: IBM To: IBM Subject: JavaMail Attachment Mime-V[More]

Extracting Blob data

Category:DefaultRelease time:-0001-11-30Views:130

Good morning, I have a table with the following: Name Null? Type DRILLING_REPORT_S VARCHAR2(19) ROW_CREATE_DATE DATE ROW_CREATOR VARCHAR2(40) REPORT_DATE DATE WELL_S VARCHAR2(19) TYPICAL_ACT_NAME VARCHAR2(40) DESCRIPTION VARCHAR2(2000) DOCUMENT_SPEC_[More]

Extract text data from dbc on the fly

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I am currently setting up a testsystem for a CAN based project with LV7.1 and Teststand 4. I have my PXI8461 CAN card sending and receiving CAN messages fine but I wish to perform some work on all channel ( signal ) information before passing[More]

How to extract text from a PDF file?

Category:DefaultRelease time:2015-10-11Views:130

Hello Suners, i need to know how to extract text from a pdf file? does anyone know what is the character encoding in pdf file, when i use an input stream to read the file it gives encrypted characters not the original text in the file. is there any p[More]

How to extract the size and date from a given file

Category:DefaultRelease time:2015-10-11Views:130

Hi, I want to extract the size and date of a file (it can be either a video, audio or text file) that the user points to the location of. But I am not sure how. Does Java have an api that can do this? If not is there some other way of doing this? Can[More]

How can i save and retrieve blob data through forms and reports...

Category:DefaultRelease time:2015-10-11Views:130

I have blob data type column and I want to save word, html, gif document in oracle database through forms 6 and retrieve the data into forms and reports. Details : I want to open .doc,.html,.gif file through a button and save it ..and i want retrieve[More]

Inserting blob data into database

Category:DefaultRelease time:2015-10-11Views:130

Hello everybody, I need insert blob data into database. that data i need to get from form can i use request.getParameter(""); for getting that file. Plz help how to get data from form to servlet and through callablestatement i need to insert int[More]

How to create longtext or blob data types in SQL using labview

Category:DefaultRelease time:2015-10-11Views:130

Hello, I am fairly new to SQL, and I'm using the labview database connectivity toolset.  Using labview 6.1 I am using the DB Tools Create Table vi to create my tables.  I want the tables to hold 1000 character strings.  But the longest string that I[More]

Migrating MySQL5 database to Oracle 10g - table with blob data fails

Category:DefaultRelease time:-0001-11-30Views:130

During data migration phase from MySQL5 to Oracle, noticed that the tables that have record length greater than 64K fails. It just says FINISHED for those tables without migrating any data. This is specially happening in the tables that have text and[More]

Hot
I'm trying to change my program from 6i to 10g I migrated libraries and every thing is ok but when I try to migrate forms I had this error ERROR opening D:\10gnkinkos\SHIFTS.fmb :oracle.forms.jdapi.JdapiException: A subclassed module could not be fou [More]
I have an old thinkpad, the R61 series, model 7755JM1. And I tried to install windows 8 pro (64bit) on it, hoping to have a taste of the new OS's touch features through remote control on my tablet. However, the installation has never been successful. [More]
hi, and thank you for your replies in advance. i'm a bit new to flex framework and flash. I want to know what software and languages I would need for the following website or web application I have some knowledge with programing and markup languages [More]
Hi      I am writing a plugin and stuck at putting an anchor to text at different points in indesign document. am using vc++. i see many interfaces related to anchored object like IAnchoedObjectInsertData,IAnchoedObjectSuite,IAnchoedObjectData ... bu [More]
Hi, How to populate the Document number and EAN code  in the segment with leading zeroes because I have checked that all fields in the segment are of charcter type. I want to know can this be handled by customizing or coding but how? Thanks PrinceHi, [More]
I know it is some time since you posted but I'm so angry with BT and the lies. We decided to take out a new contract with bt for another year 2 years ago after complaining then but this time I cant be bothered to lift my phone to talk to someone in I [More]
Hi, I followed some instructions on this forum to build up my parallax scrolling scene by Edge Animate 1.5. The layers of scene do move 'parallaxly' with the mouse scrolling,but do not follow the keyframes set up on the timeline, which should stop at [More]
hi guys im having problems with my DAL in my school project before im starting new one maybe you can help me using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data; using System.Data.OleDb; public class [More]
Hi I have successfully setup Postfix using osx.topicdesk's Frontline Spam Defence for OS X and this works very well at blocking most spam. However we have a problem with certain emails getting blocked. Today my colleague at our other office tried to [More]
never showing my file and folder in desktop and hardisk also....how to fix that....See http://download.oracle.com/javase/tutorial/uiswing/components/list.html especially the part about the wrap modes and the list renderers. For icons look at http://d [More]