Hi All,
There is a blob column in one of our Oracle database that has to be displayed to the Users in our web site.
We are coding a new REST Web API that one of our web sites is consuming the methods.
The Snap Develop is the PB 2019, not the PB 2019 R2 Beta.
The following original PB statement
SELECTBLOB ANSWER_HTML INTO :lblob_temp FROM internet_faq WHERE INTERNET_FAQ_ID = :as_primary_key_id;
was migrated manually to C# as
PbBlob lblob_temp = null; //holds the blob column value retrieved; the column name is ANSWER_HTML
PbString answerString = ""; //holds the string corresponding to the blob
var sqlStatement = new SqlQueryBuilder(); //the select created by the query builder
sqlStatement.Select("ANSWER_HTMl").From("internet_faq").WhereValue("INTERNET_FAQ_ID", as_primary_key);
validSelect = sqlStatement.Validate(_dataContext, throwError: false); //it returns True
Try
{
lblob_temp = _dataContext.SqlExecutor.Scalar<Byte[]>(sqlStatement, as_primary_key);
answerString = lblob_temp.ToString();
return answerString ;
}
Catch(Exception msgError){return msgError.message; }
The select statement always returns no rows no matter which value as_primary_key is. No Exception is raised.
If the select is changed, for instance, to retrieve a non blob column with the same key it retrieves data, like
sqlStatement.Select("QUESTION_TXT").From("internet_faq").WhereValue("INTERNET_FAQ_ID", as_primary_key);
So the as_primary_key is being passed correctly.
Am I missing some C# construction?
Any ideas what could be?
Thank you.
Regards,
Paulo Gomes
pgomes@intervalintl.com
