 |
At the beginning I would like to show you a problem which I last found in my job.
Calling stored procedures on Oracle server form MS SQL 2000 is not so easy as many of us could think.
The worst problem which we cold get is in situation when we need to get some strings of values, not tables, just strings of values.
Searching over Internet I didn’t find any sense solution of my problem.
The best tips which I have found was creating a table whit associated special trigger on the ORACLE server, which trigger started stored procedures with some input parameters and saved returned values in that table.
That solution is good but not so good for me, I was looking for a way to call stored procedures without creating tables and triggers in Oracle server.
As we call in Poland “ If you need something, build it”, I used functionality builded in MS SQL 2000 and components of T-SQL, have created some solutions which I would like to show you.
|
