| || |
Anyone ever have trouble accessing Oracle DBs? ...
I have a an Oracle table with 295 columns (I know, don't ask ;-).
When I use a query like the following, WR repeatedly crashes:
szQuery = "select * from SOMETABLE where INTID <> 0 and rownum < 100";
But when use a query like this WR works okay:
szQuery = "select SOMECOLUMN from SOMETABLE where INTID <> 0 and rownum < 100";
For the first query above, note that even though I am selecting all columns, I limit the query to only return 100 records at most. This tells me that the problem is not the amount of data returned per se, but rather the fact that I am attempting to select all columns. Is there a hard or known limit for WR in this area?
Re: Anyone ever have trouble accessing Oracle DBs? ...
I had the same issue, and as nobody else has answered as yet I will post my complicated work around. I can not believe that this is the best answer as it is very inefficient, but it is an answer......
- Do a desc TABLENAME, to get back the columns for the table
- remove the bits from the string that you do not want
- you will probably have to manipulate it a little to get the columns in the way sql would like
- do you sql with the string that equals the column names, thus removing the need for the *.
Re: Anyone ever have trouble accessing Oracle DBs?