DB tool returning as blank where the SQL query in oracle returning null

satyabratasatyabrata Posts: 5

Hi ,

We have connected to DB tool in Parasoft test to connect to oracle.

When we run the query in DB visualizer connecting to oracle for one of the column its returned as null however when we run in DB tool its returning as blank.

Is there any setting in DB tool tool return the column value same as returning in Oracle.

Thanks,
Satyabrata Das

Comments

  • jakubiakjakubiak Posts: 738 admin

    It looks like null and empty string mean the same thing in Oracle - I suspect that this is the behavior of the Oracle JDBC driver. I would like to see if there is something you can do in the SQL query to change how it gets returned?

    Also does this help?
    https://stackoverflow.com/questions/31403994/replacing-null-with-blank-cell-in-sql-query-result

  • benken_parasoftbenken_parasoft Posts: 1,011 ✭✭✭
    edited August 24

    Depending on the version of SOAtest, null values are represented in the DB Tool's SQL result XML output as either 0 or empty string. In the current release, it is empty string. So, at present, you can't disambiguate between empty string and null. This is a known limitation.

Sign In or Register to comment.