say, compare to TOAD from Quest Software rr SAS won't return data.
How to improve SAS performance?
are there paraemters I can adjust? TIA
connect to oracle as o ( path= drep .. );
create table fun as
select * from connection to o (
Oracle SQL stmts here );
Here's error msg:
ERROR: Error fetching from cursor. ORACLE error is ORA-00604: error
occurred at recursive SQL level 1
numeric or value error: character string buffer too small
ORA-06512: at line 8
ORA-01652: unable to extend temp segment
by 128 in tablespace TEMP.
NOTE: Table HYWORK.CI_DPI_STAB_SCHDL_32088 created, with 0 rows and 35