Hello
I have a problem with a function a was using frequently in older version of SQL DEVELOPER.
Exportation of CLOB column for insert generation is no more available in in the new version 20.4.1.407.
SCENARIO :
giving
with the result of the query
SELECT * FROM APP_CONFIGURATION;
contextual menu export
in version Version Version 4.0.3.16, I had the CLOB column
REM INSERTING into EXPORT_TABLE
SET DEFINE OFF;
Insert into EXPORT_TABLE (ID,ENTITYSTATUS,CONFIG,MODULE) values ('97','0','{"services":{"SocialColumnTypeCopyData":{"name":"SocialColumnTypeCopyData","dateExec":"2021-01-15T14:21:32.827+0000","success":true,"message":"Skip serviceUpdate - not applicable"},"EmailColumnTypeDropColumn":{"name":"EmailColumnTypeDropColumn","dateExec":"2021-01-15T14:21:32.751+0000","success":true,"message":"Skip serviceUpdate - not applicable"},"SocialColumnTypeDropColumn":{"name":"SocialColumnTypeDropColumn","dateExec":"2021-01-15T14:21:32.884+0000","success":true,"message":null},"SocialTableTypeDropColumn":{"name":"SocialTableTypeDropColumn","dateExec":"2021-01-15T14:21:32.973+0000","success":true,"message":null},"EmailColumnTypeCopyData":{"name":"EmailColumnTypeCopyData","dateExec":"2021-01-15T14:21:32.705+0000","success":true,"message":"Skip serviceUpdate - not applicable"},"SocialTableTypeCopyData":{"name":"SocialTableTypeCopyData","dateExec":"2021-01-15T14:21:32.929+0000","success":true,"message":"Skip serviceUpdate - not applicable"}}}','SERVICEUPDATE');
Insert into EXPORT_TABLE (ID,ENTITYSTATUS,CONFIG,MODULE) values ('99','0','{"urlQualification":null,"urlRecommendation":null,"qualificationValuesFamilies":[{"id":-10,"name":"DEFAULT","qualificationValues":[{"id":-10,"name":"OTHER","color":"#C0C0C0","unused":false,"translations":[{"langauge":"FR","libTranslation":"Autre"},{"langauge":"EN","libTranslation":"Other"}]},{"id":-20,"name":"DEMAND","color":"#3C8DBC","unused":false,"translations":[{"langauge":"FR","libTranslation":"Demande"},{"langauge":"EN","libTranslation":"Request"}]},{"id":-30,"name":"CLAIM","color":"#DD4B39","unused":false,"translations":[{"langauge":"FR","libTranslation":"Réclamation"},{"langauge":"EN","libTranslation":"Claim"}]},{"id":-40,"name":"SATISFACTION","color":"#019651","unused":false,"translations":[{"langauge":"FR","libTranslation":"Satisfaction"},{"langauge":"EN","libTranslation":"Satisfaction"}]}]}],"qualificationModels":{"DEFAULT_QUALIFICATION_MODEL":{"code":"DEFAULT_QUALIFICATION_MODEL","externalCode":null,"displayName":"Default qualification model","family":-10,"possibleValues":[-10,-20,-30,-40],"languages":null}}}','QUALIFICATION');
Insert into EXPORT_TABLE (ID,ENTITYSTATUS,CONFIG,MODULE) values ('133','0','{"servers":[{"url":"graal360-rec-els","port":9200}]}','FULLTEXT');
Insert into EXPORT_TABLE (ID,ENTITYSTATUS,CONFIG,MODULE) values ('259','0','{"version":3,"mailBoxes":{"MB_1615026090047":{"active":false,"code":"MB_1615026090047","name":"graal-rec2-form","description":"boite environnement RECETTE","parameters":{"protocol":"IMAP","user":"graal-rec2-form@lfm.lan","password":{"salt":"F5TOGFYsKgpixS2khj5PCXuVmtU=","iv":"0aQVivMG+MXDJqtgSzh33A==","value":"vRrpmQjowYOEebEiXYQ7pw=="},"notificationAddress":"","rejectedFolder":"A TRAITER","serverIn":"smtp.lfm.lan","serverOut":"smtp.lfm.lan","portIn":143,"portOut":25,"sslIn":false,"sslOut":false,"needAuthentication":true},"defaultSenderAddress":"graal-rec2-form@la-france-mutualiste.fr","defaultRecipientAddress":"graal-rec2-form@la-france-mutualiste.fr","filters":[{"code":"automessage","active":true,"name":"automessage","type":"DEFAULT","rule":null,"actions":[]}],"configurations":[{"code":"default","configuration":"default","filter":{"code":"default","active":true,"name":"default","type":"DEFAULT","rule":null,"actions":[{"type":"PROCESS","value":null},{"type":"DELETE","value":null}]},"type":"DEFAULT","modelsFields":[],"langByModel":{}}],"dictionary":{"startToken":"<","endToken":">","endIndicator":"/","entries":[{"name":"TITRE","label":"Civilité de la personne","type":"DATA","mandatory":false},{"name":"NOM","label":"Nom de la personne","type":"DATA","mandatory":false},{"name":"PRENOM","label":"Prénom de la personne","type":"DATA","mandatory":false},{"name":"CODEPOSTAL","label":"Code postal courrier de la personne","type":"DATA","mandatory":false},{"name":"TEL1","label":"Téléphone domicile","type":"DATA","mandatory":false},{"name":"TYPETACHE","label":"Code du type de tâche à créer dans le GRAAL","type":"DATA","mandatory":false},{"name":"IDMOTIFLFM","label":"Code du motif du contact à créer dans le GRAAL","type":"DATA","mandatory":false},{"name":"DATEHEUREDEMANDEE","label":"Date de l'échéance demandée pur la tâche GRAAL à créer","type":"DATA","mandatory":false},{"name":"DATENAISSANCE","label":"Date de naissance de la personne","type":"DATA","mandatory":false},{"name":"IDADHERENT","label":"Numéro Adhérent de la personne","type":"DATA","mandatory":false},{"name":"MAIL","label":"Adresse email de la personne","type":"DATA","mandatory":false},{"name":"TEL2","label":"Téléphone portable de la personne","type":"DATA","mandatory":false},{"name":"TEL3","label":"Téléphone du bureau de la personne","type":"DATA","mandatory":false},{"name":"COMMENTAIRE","label":"Commentaires","type":"DATA","mandatory":false},{"name":"IDCONSEILLERPRIV","label":"Code Media Courtage du conseiller","type":"DATA","mandatory":false},{"name":"IDPERSONNE","label":"ID Sicare de la personne","type":"DATA","mandatory":false},{"name":"UTMSOURCE","label":"Code de l'utilisateur utilisé pour les opérations de création/mises à jour dans le GRAAL","type":"DATA","mandatory":false},{"name":"CONTACT","label":"Code type de contact demandé par la personne (tel/email/courr.)","type":"DATA","mandatory":false},{"name":"MODECONTACT","label":"Code mode de contact du contact GRAAL à créer ","type":"DATA","mandatory":false},{"name":"UTMSUPPORT","label":"Code support marketing du contact GRAAL à créer ","type":"DATA","mandatory":false},{"name":"UTMCAMPAGNE","label":"Code campagne marketing du contact GRAAL à créer ","type":"DATA","mandatory":false},{"name":"BODY_HTML","label":"Corps du mail au format HTML","type":"METADATA","mandatory":false},{"name":"BODY_TEXT","label":"corps du mail au format Texte","type":"METADATA","mandatory":false},{"name":"TYPEPRODUIT","label":"code produit du contact du GRAAL","type":"DATA","mandatory":false},{"name":"ORIGINE","label":"Origine du flux (code défini dans TABLE31 )","type":"DATA","mandatory":false}]}}},"configurations":{}}','EMAIL');
in version Version 20.4.1.407 I haven't th CLOB column
REM INSERTING into CRM.APP_CONFIGURATION
SET DEFINE OFF;
Insert into CRM.APP_CONFIGURATION (ID,ENTITYSTATUS,MODULE) values ('97','0','SERVICEUPDATE');
Insert into CRM.APP_CONFIGURATION (ID,ENTITYSTATUS,MODULE) values ('99','0','QUALIFICATION');
Insert into CRM.APP_CONFIGURATION (ID,ENTITYSTATUS,MODULE) values ('133','0','FULLTEXT');
Insert into CRM.APP_CONFIGURATION (ID,ENTITYSTATUS,MODULE) values ('259','0','EMAIL');
will it be fixed quickly?