存储过程调用

//创建存储过程和执行
            func outProcedure(db * sql.DB) {
                    var err                error
                    var outInt             int
                    var createProcedureSQl string = `CREATE OR REPLACE PROCEDURE mygp4
                            (
                                    yname IN  INT ,
                                    pwd   OUT INT
                            )
                            AS
                            BEGIN
                                    pwd = yname + 1;
                            END;`
                    var querySQL           string = "begin mygp4(:yname, :pwd);end;"
                    //创建存储过程
                    _, err = db.Exec(createProcedureSQl)
                    getError(err)
                    //调用存储过程
                    _, err = db.Exec(querySQL, 1234, sql.Named("pwd",sql.Out{Dest: &outInt}))
                    getError(err)
                    fmt.Println(outInt)
            }