cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
tmg02
‎07-23-2021
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Free Webinar: Getting Started with PROC REPORT

by Calcite | Level 5 in Ask the Expert
‎11-27-2017 02:31 PM
‎11-27-2017 02:31 PM
Am I missing something? Where is the slide download link? --tmg02 ... View more

Re: Oracle error ORA-22835

by Calcite | Level 5 in SAS Programming
‎03-08-2017 09:42 PM
‎03-08-2017 09:42 PM
How do I figure out which field in the view is causing the error? I only have read rights on the Oracle view so I need to have a SAS solution. Thanks for your help. Much appreciated. ... View more

Re: Oracle error ORA-22835

by Calcite | Level 5 in SAS Programming
‎03-08-2017 09:40 PM
‎03-08-2017 09:40 PM
Hi Laurie,   Thanks for offering to help.  I'm not actually referencing the CLOB column.  The code references the Oracle view and I assume that one of the fields in this view is a CLOB or BLOB.  I'm not sure which field is throwing the error, but SAS successfully reads over 200,000 records before throwing the error.  Unfortunately, there is no data dictionary available for the view and IT is not willing to provide one.  Maybe I should start with a proc contents to see what is actually stored on Oracle?   -Todd ... View more

Oracle error ORA-22835

by Calcite | Level 5 in SAS Programming
‎03-08-2017 08:33 PM
‎03-08-2017 08:33 PM
I am trying to read an Oracle view using Windows Base SAS.  The SAS error log is returning and error message "Error fetching from cursor.  ORACLE error is ora-22835.  Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4254, maximum: 4000).  SAS read 210000 observations before abnormally terminating.  Does anyone know a solution to this issue?   Thanks,  tmg02  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-23-2021 07:08 PM
Quick links