public void buildInDeclare(StringBuilder sb, PLSQLargument inArg) { // Validate. if (!hasCompatibleType()) { throw QueryException.compatibleTypeNotSet(this); } if ((getTypeName() == null) || getTypeName().equals("")) { throw QueryException.typeNameNotSet(this); } sb.append(" "); sb.append(databaseTypeHelper.buildTarget(inArg)); sb.append(" "); sb.append(getTypeName()); sb.append(";"); sb.append(NL); sb.append(" "); sb.append(databaseTypeHelper.buildCompatible(inArg)); sb.append(" "); sb.append(getCompatibleType()); sb.append(" := :"); sb.append(inArg.inIndex); sb.append(";"); sb.append(NL); }
@Override public void buildInDeclare(StringBuilder sb, PLSQLargument inArg) { databaseTypeHelper.declareTarget(sb, inArg, this); sb.append(" := :"); sb.append(inArg.inIndex); sb.append(";"); sb.append(NL); }
protected String getTruncatedSHA1Name(String argName, String prefix) { if (argName.length() >= ARGNAME_SIZE_LIMIT) { StringBuilder sb = new StringBuilder(); //the truncated SHA is great, but a PL/SQL identifier //can't start with a number, so use prefix sb.append(prefix); sb.append(getTruncatedSHA1Hash(argName)); return sb.toString(); } return argName; }
public void buildInDeclare(StringBuilder sb, PLSQLargument inArg) { // Validate. if (!hasCompatibleType()) { throw QueryException.compatibleTypeNotSet(this); } if ((getTypeName() == null) || getTypeName().equals("")) { throw QueryException.typeNameNotSet(this); } sb.append(" "); sb.append(databaseTypeHelper.buildTarget(inArg)); sb.append(" "); sb.append(getTypeName()); sb.append(";"); sb.append(NL); sb.append(" "); sb.append(databaseTypeHelper.buildCompatible(inArg)); sb.append(" "); sb.append(getCompatibleType()); sb.append(" := :"); sb.append(inArg.inIndex); sb.append(";"); sb.append(NL); }
public void buildInDeclare(StringBuilder sb, PLSQLargument inArg) { // Validate. if (!hasCompatibleType()) { throw QueryException.compatibleTypeNotSet(this); } if ((getTypeName() == null) || getTypeName().equals("")) { throw QueryException.typeNameNotSet(this); } sb.append(" "); sb.append(databaseTypeHelper.buildTarget(inArg)); sb.append(" "); sb.append(getTypeName()); sb.append(";"); sb.append(NL); sb.append(" "); sb.append(databaseTypeHelper.buildCompatible(inArg)); sb.append(" "); sb.append(getCompatibleType()); sb.append(" := :"); sb.append(inArg.inIndex); sb.append(";"); sb.append(NL); }
public void buildBeginBlock(StringBuilder sb, PLSQLargument arg, PLSQLStoredProcedureCall call) { String sql2PlName = call.getSQL2PlName(this); if (sql2PlName == null) { // TODO exception throw new NullPointerException("no SQL2Pl conversion routine for " + typeName); } String target = databaseTypeHelper.buildTarget(arg); String compat = databaseTypeHelper.buildCompatible(arg); sb.append(" "); sb.append(target); sb.append(" := "); sb.append(sql2PlName); sb.append("("); sb.append(compat); sb.append(");"); sb.append(NL); }
public void buildBeginBlock(StringBuilder sb, PLSQLargument arg, PLSQLStoredProcedureCall call) { String sql2PlName = call.getSQL2PlName(this); if (sql2PlName == null) { // TODO exception throw new NullPointerException("no SQL2Pl conversion routine for " + typeName); } String target = databaseTypeHelper.buildTarget(arg); String compat = databaseTypeHelper.buildCompatible(arg); sb.append(" "); sb.append(target); sb.append(" := "); sb.append(sql2PlName); sb.append("("); sb.append(compat); sb.append(");"); sb.append(NL); }
public void buildBeginBlock(StringBuilder sb, PLSQLargument arg, PLSQLStoredProcedureCall call) { String sql2PlName = call.getSQL2PlName(this); if (sql2PlName == null) { // TODO exception throw new NullPointerException("no SQL2Pl conversion routine for " + typeName); } String target = databaseTypeHelper.buildTarget(arg); String compat = databaseTypeHelper.buildCompatible(arg); sb.append(" "); sb.append(target); sb.append(" := "); sb.append(sql2PlName); sb.append("("); sb.append(compat); sb.append(");"); sb.append(NL); }
@Override public void translate(PLSQLargument arg, AbstractRecord translationRow, AbstractRecord copyOfTranslationRow, List<DatabaseField> copyOfTranslationFields, List<DatabaseField> translationRowFields, List translationRowValues, StoredProcedureCall call) { if (hasCompatibleType()) { super.translate(arg, translationRow, copyOfTranslationRow, copyOfTranslationFields, translationRowFields, translationRowValues, call); } else { for (PLSQLargument argument : fields) { databaseTypeHelper.translate(argument, translationRow, copyOfTranslationRow, copyOfTranslationFields, translationRowFields, translationRowValues, call); } } }
public int computeOutIndex(PLSQLargument outArg, int newIndex, ListIterator<PLSQLargument> i) { return databaseTypeHelper.computeOutIndex(outArg, newIndex); }
public void translate(PLSQLargument arg, AbstractRecord translationRow, AbstractRecord copyOfTranslationRow, Vector copyOfTranslationFields, Vector translationRowFields, Vector translationRowValues, StoredProcedureCall call) { if (hasCompatibleType()) { super.translate(arg, translationRow, copyOfTranslationRow, copyOfTranslationFields, translationRowFields, translationRowValues, call); } else { for (PLSQLargument argument : fields) { databaseTypeHelper.translate(argument, translationRow, copyOfTranslationRow, copyOfTranslationFields, translationRowFields, translationRowValues, call); } } }
public void translate(PLSQLargument arg, AbstractRecord translationRow, AbstractRecord copyOfTranslationRow, List<DatabaseField> copyOfTranslationFields, List<DatabaseField> translationRowFields, List translationRowValues, StoredProcedureCall call) { if (hasCompatibleType()) { super.translate(arg, translationRow, copyOfTranslationRow, copyOfTranslationFields, translationRowFields, translationRowValues, call); } else { for (PLSQLargument argument : fields) { databaseTypeHelper.translate(argument, translationRow, copyOfTranslationRow, copyOfTranslationFields, translationRowFields, translationRowValues, call); } } }
public int computeOutIndex(PLSQLargument outArg, int newIndex, ListIterator<PLSQLargument> i) { return databaseTypeHelper.computeOutIndex(outArg, newIndex); }
public void buildOutAssignment(StringBuilder sb, PLSQLargument outArg, PLSQLStoredProcedureCall call) { databaseTypeHelper.buildOutAssignment(sb, outArg, call); }
public int computeInIndex(PLSQLargument inArg, int newIndex, ListIterator<PLSQLargument> i) { return databaseTypeHelper.computeInIndex(inArg, newIndex); }
public int computeInIndex(PLSQLargument inArg, int newIndex, ListIterator<PLSQLargument> i) { return databaseTypeHelper.computeInIndex(inArg, newIndex); }
public void logParameter(StringBuilder sb, Integer direction, PLSQLargument arg, AbstractRecord translationRow, DatabasePlatform platform) { databaseTypeHelper.logParameter(sb, direction, arg, translationRow, platform); }
public void logParameter(StringBuilder sb, Integer direction, PLSQLargument arg, AbstractRecord translationRow, DatabasePlatform platform) { databaseTypeHelper.logParameter(sb, direction, arg, translationRow, platform); }
public int computeOutIndex(PLSQLargument outArg, int newIndex, ListIterator<PLSQLargument> i) { return databaseTypeHelper.computeOutIndex(outArg, newIndex); }
public int computeOutIndex(PLSQLargument outArg, int newIndex, ListIterator<PLSQLargument> i) { return databaseTypeHelper.computeOutIndex(outArg, newIndex); }