> Now I checked GO does not support reuse of same parameters Where or how did you check this?
> so if I have already used order_id as a parameter while passing query to be executed I can not use the order_id parameter anywhere else in the query. You haven't given an example of a query that doesn't work in the way you expect. For example: insert into foo(a, b, c) values (:order_id, :order_id, :order_id); What happens? If you do find this doesn't work, it's possibly a limitation with Oracle and not with Go. See: https://github.com/launchbadge/sqlx/issues/951 However, Python's Oracle binding implies this should work: https://python-oracledb.readthedocs.io/en/latest/user_guide/bind.html#duplicate-bind-variable-placeholders As for the stored procedure: > sql.Out{Dest: &rows}, // 🔥 THIS IS THE KEY You haven't show what parameter :20 is being used for, or why you need to pass this in the first place. Nor have you shown which Oracle client library you're using. The best thing to do would be to write a fresh, minimal, standalone program which demonstrates the problem you are trying to solve - with an associated dummy stored procedure. Then (a) you don't need to share the code you are working on, (b) someone else can use it to reproduce your problem, and (c) in the process of boiling it down to a reproducer, it's quite common that you find the solution. Good luck! -- You received this message because you are subscribed to the Google Groups "golang-nuts" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/golang-nuts/ed78a5f5-c987-4a5d-bd8c-fa810a3257dbn%40googlegroups.com.
