i need to download a file directly from a table's BLOB column .
i used this procedure, but i got the error:
SQL> exec download_blob;
begin download_blob; end;
ORA-06550: line 2, column 7:
PLS-00905: object IFRSCD.DOWNLOAD_BLOB is invalid
ORA-06550: line 2, column 7:
PL/SQL: Statement ignored
The code is:
[Code]....
my goal is to save an jpeg image in a blob field in oracle. give me code in order to do this.
View 5 Repliesdatabase type field BLOB in oracle but if i use MS SQL and field type as image then this below line code work fine.
here trying to save image in oracle database but system giving me below line error
unimplemented or unreasonable conversion requested
here is my code
[Code]....
I'm not a core web programmer. I'm building an web application which will track defects, using ASP.Net and MySQL. There is a requirement for me to attach multiple files to each review/defect.
how to upload files to MySQL and generate link for the uploded files in the ASP.Net form? Also when the user clicks the link I need to retrieve the file from the MySQL database and download the file to a directory in the client pc.
I have a MySql function that i wrote in Query Broswer, that adds a new entry into the "customer" table.
The values are provided from an .aspx page, and after the insertion, the function should return "1" (int value). So, my .aspx page is:
[Code]....
I am developing web application using csharp and MS SQL as database. There is a column in table that is storing values which as numbers and letters. Letters are in front like JK26262, JK26263,JK26263.
Now I want to select numbers only from a table column and leave letters. In other words I want an select statement that will select values as follows:
26262
26263
26263
How can Iachieve this?
i have a question how to retrieve the row values as a column. please check the below tables i need the query for this table.
[Code]....
I'm writing a function in "Query Browser" to add some values to a table.
The function should get this value when the stored procedure is called upon, thus te code looks like:
INSERT INTO customer(customer_name, customer_city) VALUES (@customer_name, @customer_city);
But when trying to execute the function, it says "customer_name can't be null"
i thought maybe it just waiting for the values to be sent from .aspx page, but yet again, i get the same error message.
I'm getting a "no data exists for the row/column" error when i am giving wrong value in key column and press button to import data from excel,how can i fix this error and avoid collapsing the application.
[Code]....
I have read the excel in asp.net. I am using OledbDatareader for read the column name.
[Code]....
Now my problem is the "date" field. If Excel sheet having column name "Date" then i got the error. i could not use the Column index because its also not fix. How can i ignore the upper case charactors in column name ?
I want to update multiple column of a table using subquery ...My sample code is shown below
[Code]....
its throwing syntax error...I dont know where i commiting mistake.
I am doing Import/Export. While export i want to disable some column in excel sheet, so during upload or import same primary key I can use, instead of user modify such column.
View 1 Repliesenvironment: VS2008, MySQL 5.1.45, .net Connector 6.2.2
Error msg:
NoNullAllowedException: Column 'idNames' does not allow nulls.
The MySQL DB has on "idNames" (Primary Key) a tick-mark for: primary Key, Not Null, Auto-Increment Also: I can add/retrieve records via the 'MySQL Query Browser'; I see the data via VS2008 'Preview Data'!
As said in the comment below; when the 'idNames' is explicitely given the rows.add works fine. So it seems that I miss something around the 'auto-increment' business!
[code].....
I tried to query an excel file which contains a lot of customers' information but my problem is most of those don't have a specific column names. E.g. it's in the following format. (Excel File)
A B C
Info1 blur blur
Info2 blur blur
Info3 blur blur
So, when I query using SqlDbDataAdapter, in my DataTable, info1 blur blur becomes column header. e.g. it's in the following format. (DataTable)
Info1 blur blur
Info2 blur blur
Info3 blur blur
I been working on it so that it actually goes down one row and Change the column name in the DataTable into some appropiate name. Something like the following format.
Name1 Name2 Name 3
Info1 blur blur
Info2 blur blur
Info3 blur blur
Is there any way that I could work around it rather than actually going back to change the excel files ? Because I have like 1,000 excel files in that kinda format and seriously giving me headache now.
(int) faultsGroup is 0 or 1 but i always get this error: Column 'FaultGroup' cannot be null Does anyone tell me why? Syntax looks ok.
[Code]....
I am currently developing a web application that receives data from an on-site database. The database developers have developed some web-services that I am able to call and send/receive data to and from the the database.
When I want to display an image the method returns the image in BLOB format. My question is: what is the best way to convert BLOB to .jpg or .bmp so I can display the image correctly?
I use Mysql database, in this i create two table A, B. table A column x and is FK of second table B's column m,n,o provide does it possible that x referncing to foreign key of table B columns m, n , and o all.
View 2 RepliesI have an application where a Word document is filled out and saved as a blob.
I want to display that document over the web but I do not want it to open in Word where anyone can edit the fields.
I was hoping to convert the word blob to a pdf on the fly.
We are storing images in a DB2 database and would like to display them on the web page.
View 2 RepliesI am using C#. I am consuming a webservice. The webservice has a method, which has the return type as blob. The webservice serializes the data before sending as blob.I am able to access the webservice method, but I am not sure how to store the value, as the return type is a blob.I have tried this:
Service1.TestService serv = new Service1.TestService();
? = serv.Custom_methodname(true);
How to assign the output as it is a blob variable?
I have a blob column in mysql database and i am inserting different kind of files like .pdf, .jpeg etc in to that database column.While retrieving that blob data, i want to know what kind of file data i am retrieving(whether it is jpg or pdf) so that i can save that in the known format.
View 4 RepliesI would like to know which is better? Storing images in BLOB or in the File System ? I've got around 400 to 5000 images.
And at run time there are chances where I'll need to retirieve about 100 - 150 images.
I want to import csv file(already uploaded in blob storage) in Azure. For example I have uploded test.csv on blob storage, now i just want to import that test.csv file in .net(azure) and after importing i will insert that data into azure database. I am using C# .net.
Creating a cvs file with all rows. Upload it as blob. Parse it with a Worker role and insert it in the sql azure db.
Is it possible to upload and Save Excel file as blob in Sql table through web application?
I do not need to query excel file, just be able to upload and download excel file as is.
I am pulling word documents that have been stored in our db as blobs and presenting them to the user. As you can see below, I am writing to the http stream via BinaryWrite. This is causing the Microsoft Word application to open in a separate window. My goal was to open the word document inside of the browser instead. Preferably inside of an iframe within the browser. Is there a way to target an iframe by some analog of the method below?
[Code]....