yuem — 4-Jun-2010/23:20:47-7:00
has anybody ever used rebol to call a stored procedure in either a Ms Sql server database or from an oracle database?
Endo — 6-Jun-2010/10:55:50-7:00
I did in mssql using odbc, it that what you ask?
p: open odbc://mydsn
r: insert p "EXEC mysp('myvalue')"
probe r
yuem — 7-Jun-2010/22:59:49-7:00
Thanks Enzo, I will try it this way.
Endo — 8-Jun-2010/4:19:34-7:00
Oops, that example is incomplete!
Here is a working one.
R E B O L []
db-conn: open odbc://myodbcdsn
conn: first db-conn
exec: func [sql] [
insert conn sql
result: copy conn
length? result
]
dump: does [
forall result [
print first result
]
]
halt
usage:
exec "EXEC mysp('myvalue')"
>> 5 ;number of rows.
dump ;to see the result set
note that db connection port and command port are different ports.