Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 EXECUTE Openquery Oracle

Author  Topic 

Rookie Tom
Starting Member

1 Post

Posted - 2007-01-26 : 11:17:04
Hello all,
first sorry for my English.
I have an sql2005 Server and an Oracle Server. On the Ora Server there is an Procedure that i call :

declare
vNumber NUMBER;
begin

TOMDBOWNER.GET_TS(vNumber);
DBMS_OUTPUT.PUT_LINE('vNUMBER='||vNumber);
end;
/
That runs. But i must start it from the SQL Server and store the result VNumber on an SQL Table..
How can i do this please.
Regards
Thomas
   

- Advertisement -