Some of the columns are transferred from VARCHAR2 to CLOB and what could be done to prevent the data type transformations on SAS. Later, i've got the following error while loading the existing table by typing ORALIB.CRM_YENILEME_LISTE on OUTPUT NAME in ORACLE.Increasing number of the columns which is transformed into CLOB every time i run ORALIB.CRM_YENILEME_LISTE although i take the columns which are last transformed into CLOB as a result of the format inconsistency and i also wanted to prevent it.Also how to find the LIBNAME SYNTAX forming the LIBRARY description of ORALIB LIBRARY. The error i get while trying to send data from ORALIB is given below. I am waiting for your help.

the error i receive typing ORALIB.CRM_YENILEME_LISTE :

NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables.

it didn't have any problems before but for the last 3 or 4 transfers, the data type which is varchar in the some parts of the table is transformed into CLOB. To solve the problem temporarily, parts transformed into CLOB are put in the bottom of the table according DBA's recommendations however CLOB parts change everytime they repeat the process.

when i transfer data from SAS Work to any SAS base library, i didn't get same problem.