gorm-oracle
gorm-oracle copied to clipboard
Oracle stored procedure OUT Variables
Hi, I am getting error numeric or value error: character string buffer too small when trying to map output variables of oracle stored procedure to go variables, kindly assist.
result := database.DB.Exec(`BEGIN
ProcedureName(
@amount,
'010',
@sourceUser,
@UPN, @IssueDate, @Errno, @Errtxt);
END;`,
sql.Named("amount", amount),
sql.Named("sourceUser", sourceUser),
sql.Named("UPN", sql.Out{Dest: &outputs.UPN}),
sql.Named("IssueDate", sql.Out{Dest: &outputs.UPN}),
sql.Named("Errno", sql.Out{Dest: &outputs.UPN}),
sql.Named("Errtxt", sql.Out{Dest: &outputs.UPN}))