Comments by Eagle32 (Top 15 by date)

Thanks, Now instead of a List of Products in the dictionary if i have just a Dictionary<string, product=""> how would i achieve the above i.e filtering and converting to a list?

Apologies, i have updated my actual problem and my SQL.
I have checked the API, the Product_Code is actually always populated in the database and will contain a real value (i.e not "UNKNOWN") and the Product_Type is not always populated with an actual value.

What i would like to do is filter the dictionary collection and return just a List<products>. I want to filter using the user provided ProductCodes List and the ProductTypes List.

I want to match on the ProductCode using the ProductCodeList provided by the end user. This list will never contain "UNKNOWN".

Now regarding user providedlist called ProductTypes List, if the value contains "UNKNOWN", i want to match on the null value of the ProductType property of the Product that exist in that List<product> in the Dictionary i mentioned. I then want to replace the null value of the property with "UNKNOWN".

Apologies, I have updated my actual problem and my SQL. I have looked at the API i am working with and the ProductCode in the Products table is always populated and therefore never null.

However ProductType can be null and the data i am working with have several entries which the ProductType is NULL. I want to match on this value and if the value is NULL and the value in the user provided list called ProductTypes is "UNKNOWN" i want to replace the value of the ProductType where the value is NULL which exists in the Dictionary<string, list<product="">> with "UNKNOWN".

I am asking how would i filter the data that i get back based on the user provided inputs where the return value's data structure is of the following format Dictionary<string, list<product="">>();

Mika, regarding your commen "works fine as long as you choose a value that cannot exist in the original data. Otherwise you could have false results, depending on the logic" can you elaborate on this please? Thanks

Is there a way to store byte[] array of data in PL/SQL. Here is what i have:
but i don't know how to store the byte[] array of data in the BLOB column. Currently i can only insert the physical file into the database:

DECLARE
l_dir VARCHAR2(10) := 'IMAGES';
l_file VARCHAR2(25) := 'test.jpg';
l_bfile BFILE;
l_blob BLOB;

BEGIN
INSERT INTO IMAGE_TBL (IMG_ID, IMG_DESC, IMAGE_DATA, IMG_EXT)
VALUES (IMAGE_TBL_SEQ.NEXTVAL, l_file, empty_blob(), '.jpg')
RETURN IMAGE_DATA INTO l_blob;

l_bfile := BFILENAME(l_dir, l_file);
--Opens BFILE for read-only access. BFILE data may not be written through the database.
DBMS_LOB.fileopen(l_bfile, DBMS_LOB.file_readonly);
--Copies all or part of the source external LOB to a destination internal LOB
DBMS_LOB.loadfromfile(l_blob,
l_bfile,
DBMS_LOB.getlength(l_bfile));
--Release the resource.
DBMS_LOB.fileclose(l_bfile);

--Save the changes. This will do the actual insert of the image
COMMIT;
END;

Ok, thats great. I will give that a go.

Yeah that is also true. In regards to Oracle and PL/SQL for writing images is there anything to for me to remember? I could be passing in 1MB images.

Yes that's correct. I should have made myself clearer, the insert statement i have used isn't the actual code i am going to use as final solution. It is merely for debugging purposes.

Also in addition to my previous question, how can i adapt this code so that i only insert the studentBioID that belongs to the student? i.e if that student doesn't have a studentBioID then we do not populate it for that student.

I appreciate your assistance. Would this work in PL/SQL as I am using PL/SQL developer?