var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: executing (from sql server 2000) procedures from oracle package through linkserver
I deaply need to know how to execute procedures from package in oracle, from sqlserver 2000 using linkserver.
Thank you very much,
Re: executing (from sql server 2000) procedures from oracle package through linkserver
Just ot clarify: are you trying to execute an Oracle Stored procedure using SQL Server with the Oracle server configured as a Linked Server?
Or are you trying to execute a SQL stored procedure from Oracle?
Sorry, I wasn't entirely clear on your intent from your question.
Well .. you cant directly execute a stored procedure in ORACLE from SQL Server
If you really need to do that .. here is a get around
1. Create a table in Oracle .. lets say execProc
2. On update of the table make a trigger in oracle to execute a stored procedure.
3. Update the oracle table through linked server query
Get yourself a copy of the The Holy Book
order has no physical Brett in The meaning of a Kaiser . -database data