SUPPORT / SAMPLES & SAS NOTES
Problem Note 64728: "ERROR: Column 'ROWNUM' not found or cannot be accessed" occurs when you use PROC FEDSQL with explicit pass-through with an Oracle caslib
 |  |  |  |  |
You encounter an error when you use PROC FEDSQL under the following conditions:
- You use explicit pass-through with an Oracle caslib.
- The caslib contains NUMREADNODES = 0.
In this scenario, you receive the following error:
ERROR: Column "ROWNUM" not found or cannot be accessed
ERROR: Column "SYSDATE" not found or cannot be accessed
ERROR: The action stopped due to errors. ERROR: The FedSQL action was not successful.
ERROR: Column "SYSDATE" not found or cannot be accessed
ERROR: The action stopped due to errors. ERROR: The FedSQL action was not successful.
For example, you encounter this issue when you run code similar to the following:
LIBNAME mycas SASIOCA SESSREF=mySession;
caslib oralib datasource=(srctype="oracle" username="SCOTT" password="tiger"
path="ora11g" schema="SCOTT" numReadNodes=0);
proc fedsql sessref=mySession _method;
create table casuser.tb_teste{options replace=true} as
select * from connection to oralib (
select sysdate as c1, rownum as c2 from Employee
);
quit;
caslib oralib datasource=(srctype="oracle" username="SCOTT" password="tiger"
path="ora11g" schema="SCOTT" numReadNodes=0);
proc fedsql sessref=mySession _method;
create table casuser.tb_teste{options replace=true} as
select * from connection to oralib (
select sysdate as c1, rownum as c2 from Employee
);
quit;
To work around this issue, do not use NUMREADNODES = 0 in the caslib.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Connector to Oracle | Linux for x64 | V.03.04 | V.03.05 | Viya | Viya |