search

alexbrainman / odbc

odbc driver written in go
BSD 3-Clause "New" or "Revised" License
352 stars 140 forks source link

Adding support for stored procedures with output parameters #110

Closed markotikvic closed 6 years ago

markotikvic commented 6 years ago

Are there plans for doing this in the near future?
Or do you have any idea how would one go about implementing this?

Thanks.

alexbrainman commented 6 years ago

You would have to explain what exactly your problem is.

If you search the source for TestMSSQLExecStoredProcedure, you can see how to call MS SQL Server stored procedure with existing code. Is that not enough?

Thank you.

Alex

markotikvic commented 6 years ago

It looks like that's what I'm looking for. Thanks.

The documentation does not cover the topic and I don't have time to go over source code of every package I intend to use.

markotikvic commented 6 years ago

I just got around to this. My question was about calling stored procedures with OUTPUT parameter(s).

Sybase: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36272.1550/html/commands/X30305.htm (under output)

Go: https://golang.org/pkg/database/sql/#Out

I'm just curious if this is in the plans for the future.
Calling regular procedures works as expected.

Thanks.

Marko

alexbrainman commented 6 years ago

Go: https://golang.org/pkg/database/sql/#Out

I do not use this facility myself. So I have no plan spending my time to implement this.

If you need this, you would have to do it yourself. I am happy to help with whatever does not take much of my time. Sorry.

Alex

markotikvic commented 6 years ago

OK. If I get around to it I'll ask you in case I get stuck.

Thanks.