Oracle DDL export from SAS - get_ddl truncation issue

When we grab the complete DDL from Oracle, please increase DBMAX_TEXT value to avoid the truncation issue.

proc sql;
 connect to ORACLE 
        (DBMAX_TEXT=5000 READBUFF=32767 user=xxx password=xxx);

    create table ddl as
    select txt 
    from connection to ORACLE 
    (
        select dbms_metadata.get_ddl('TABLE', table_name) txt
        from user_tables
    );

    disconnect from ORACLE;
quit;