ORA-01489: result of string concatenation is too long

[koukou1234567]

error: ORA-01489: result of string concatenation is too long
error occur at position: 568

this problem for reason

[koukou1234567]

about command: dbtpl schema oracle://xx:xx@xxxx:1521/xxxx -o gwclerk

[kenshaw]

@koukou1234567 Can you share more about the actual schema that dbtpl is being used with? Additionally, can you enable verbose (-v) output sand copy/paste the last SQL query that is displayed on the screen before the error? Further, can you execute that query against the database yourself to see what the issue is?

My guess here is that there's a limit on the type being used in the introspection query, against a stored procedure that has an extremely long definition that overflows it. This may not be rectifiable, instead the only thing that may be possible would be to disable retrieving the actual stored proc definitions, which aren't really necessary to retrieve for the core Go code generation.

[salvadorcea3]

Hi im having the same problem heres the query direct over Oracle Database 19c

[salvadorcea3]

adding this seems to solve the error:
listagg(s.text, ' ' ON OVERFLOW TRUNCATE )