Support for sql.Out parameters

[kogan69]

Suppose that I'm calling a stored procedure via database.sql and I have a number of output parameters, each of which is a cursor. Is there support for this in this package?
I mean something like this:

func main() {

	db, err := sql.Open("ora", "u/p@host:1521/DB")

	if err != nil {
		panic(err)
	}

	stmt, err := db.Prepare("call sp_get_user_state(:i_user_guid, :o_cur_users,:o_cur_auth_users,:o_cur_acct_accounts,:o_cur_settings)")

	if err != nil {
		panic(err)
	}


	guid := "0028B251D49B9455E050CB0A336D4670"


	r1 := &sql.Rows{}
	r2 := &sql.Rows{}
	r3 := &sql.Rows{}
	r4 := &sql.Rows{}
	res, err := stmt.Exec(guid,
		sql.Named("o_cur_users", sql.Out{Dest:r1}),
		sql.Named("o_cur_auth_users", sql.Out{Dest:r2}),
		sql.Named("o_cur_acct_accounts", sql.Out{Dest:r3}),
		sql.Named("o_cur_settings",sql.Out{Dest:r4} ),
		)

	if err != nil {
		panic(err)
	}

	fmt.Println(res)



}

[tgulacsi]

sql.Out is not supported yet.
Use &ora.Rset as parameters, and then their methods to retrieve the rows.

[kogan69]

Thanks for the reply! I do use what you’ve suggested already. My intention, however, was to stay within database.sql paradine. However, I could not find a way to execute a statement that returns a cursor(s) using this package. Ideally, for me :), I’d love to have a way to call sql.Exec with out params that are sql.Rows. Do you think there’s any way on earth that we could accomplish this? I’d gladly volunteer myself to this task if you have an idea what would be the implementation approach.... Cheers, LK

…

On Nov 12, 2017, at 4:23 PM, Tamás Gulácsi ***@***.***> wrote: sql.Out is not supported yet. Use &ora.Rset as parameters, and then their methods to retrieve the rows. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.

[tgulacsi]

I'm waiting for suggestions:
https://groups.google.com/forum/#!topic/golang-sql/HNvcgScdyt8
https://groups.google.com/forum/#!topic/golang-nuts/-mIE85Pde5E

[kogan69]

I see! Thanks a lot. If you need any help, please, count me in :) Cheers, LK

…

On Nov 13, 2017, at 11:53 AM, Tamás Gulácsi ***@***.***> wrote: I'm waiting for suggestions: https://groups.google.com/forum/#!topic/golang-sql/HNvcgScdyt8 https://groups.google.com/forum/#!topic/golang-nuts/-mIE85Pde5E — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or mute the thread.