gorm-oracle icon indicating copy to clipboard operation
gorm-oracle copied to clipboard

Oracle stored procedure OUT Variables

Open kechkibet opened this issue 10 months ago • 1 comments

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}))

kechkibet avatar Apr 25 '24 14:04 kechkibet