chore(TPS-5200): Add patch release notes

* Add warning for long strings as varchar

PATCH_RELEASE_NOTE.md

@@ -0,0 +1,66 @@
+---
+version: 7.2.1
+module: https://talend.poolparty.biz/coretaxonomy/42
+product:
+- https://talend.poolparty.biz/coretaxonomy/23
+---
+
+# TPS-5200
+
+| Info             | Value |
+| ---------------- | ---------------- |
+| Patch Name       | Patch\_20220420_TPS-5200\_v1-7.2.1 |
+| Release Date     | 2022-04-20 |
+| Target Version   | 20190620_1446-V7.2.1 |
+| Product affected | Talend Studio |
+
+## Introduction
+
+This is a self-contained patch.
+
+**NOTE**: For information on how to obtain this patch, reach out to your Support contact at Talend.
+
+## Fixed issues
+
+This patch contains the following fixes:
+
+- TPS-5200 [7.2.1] "Parameter Type Conflict" reported when using tOracleSP component with CLOB/AUTO-MAPPING (TDI-47802)
+
+## Prerequisites
+
+Consider the following requirements for your system:
+
+- Talend Studio 7.2.1 must be installed.
+
+## Installation
+
+### Installing the patch using Software update
+
+1) Logon TAC and switch to Configuration->Software Update, then enter the correct values and save referring to the documentation: https://help.talend.com/reader/f7Em9WV_cPm2RRywucSN0Q/j9x5iXV~vyxMlUafnDejaQ
+
+2) Switch to Software update page, where the new patch will be listed. The patch can be downloaded from here into the nexus repository.
+
+3) On Studio Side: Logon Studio with remote mode, on the logon page the Update button is displayed: click this button to install the patch.
+
+### Installing the patch using Talend Studio
+
+1) Create a folder named "patches" under your studio installer directory and copy the patch .zip file to this folder.
+
+2) Restart your studio: a window pops up, then click OK to install the patch, or restart the commandline and the patch will be installed automatically.
+
+### Installing the patch using Commandline
+
+Execute the following commands:
+
+1. Talend-Studio-win-x86_64.exe -nosplash -application org.talend.commandline.CommandLine -consoleLog -data commandline-workspace startServer -p 8002 --talendDebug
+2. initRemote {tac_url} -ul {TAC login username} -up {TAC login password}
+3. checkAndUpdate -tu {TAC login username} -tup {TAC login password}
+
+## Uninstallation
+Backup the Affected files list below. Uninstall the patch by restore the backup files.
+
+## Affected files for this patch
+
+The following files are installed by this patch:
+
+- {Talend\_Studio\_path}/plugins/org.talend.designer.components.localprovider_7.2.1.20190614_0309/components/tOracleSP/tOracleSP_main.javajet

main/plugins/org.talend.designer.components.localprovider/components/tOracleSP/tOracleSP_main.javajet

@@ -39,6 +39,7 @@ imports="
 CodeGeneratorArgument codeGenArgument = (CodeGeneratorArgument) argument;
 INode node = (INode) codeGenArgument.getArgument();
 String cid = node.getUniqueName();
+boolean isLog4jEnabled = ("true").equals(ElementParameterParser.getValue(node.getProcess(), "__LOG4J_ACTIVATE__"));
 
 List<Map<String, String>> spArgs =
 	(List<Map<String, String>>) ElementParameterParser.getObjectValue(node, "__SP_ARGS__");
@@ -188,7 +189,7 @@ if (canGenerate) {
      			  		method = "Bytes";
      	  			} else if (("Integer").equals(typeToGenerate)) {
     		 	   		method = "Int";
-    		 	   	} else {
+    				} else {
     					method = typeToGenerate.substring(0, 1).toUpperCase() + typeToGenerate.substring(1);
     				}
     				
@@ -210,12 +211,25 @@ if (canGenerate) {
 						oracle.xdb.XMLType xmlType_<%=cid%> = oracle.xdb.XMLType.createXML(connection_<%=cid%>, <%=inConnectionName%>.<%=argName%>);
 						statement_<%=cid%>.setObject(<%=argIndex%>, xmlType_<%=cid%>);
 						<%
-					} else {
-    					%>
-    					statement_<%=cid%>.set<%=method%>(<%=argIndex%>, <%=inConnectionName%>.<%=argName%>);
-    					<%
-    				}
-    				
+                    } else if (("String").equals(typeToGenerate) && "CLOB".equals(dbType)) {
+%>
+                        java.sql.Clob clob_<%=cid %> = connection_<%=cid %>.createClob();
+                        clob_<%=cid %>.setString(1, <%=inConnectionName%>.<%=argName%>);
+                        statement_<%=cid%>.setClob(<%=argIndex%>, clob_<%=cid %>);
+<%
+                    } else {
+                        if (isLog4jEnabled && ("String").equals(typeToGenerate)) {
+%>
+                            if (<%=inConnectionName%>.<%=argName%>.length() > 4000) {
+                                log.warn("String value is too long for VARCHAR type");
+                            }
+<%
+                        }
+%>
+                        statement_<%=cid%>.set<%=method%>(<%=argIndex%>, <%=inConnectionName%>.<%=argName%>);
+<%
+                    }
+
     				if (nullable) {
     					%>
     					}