Sorry if this is very stupid question, but i've spent too long searching for the answer:
I have a linked Oracle server set up for RPC in SQL server 9 db. How do I call it? I've tried this, but gives Unspecified error:
"
OLE DB provider "OraOLEDB.Oracle" for linked server "SANSORA1" returned message "Unspecified error".
"
From this:
declare @.UserName char(20) -- Current Username
declare @.Password varchar(20) -- Current Password
declare @.PasswordNew varchar(20) -- New Password
declare @.PasswordCfm varchar(20) -- Confirm New Password
set @.UserName = '900878'
set @.Password = '900878'
set @.PasswordNew = '777'
set @.PasswordCfm = '777'
declare @.return int
exec SANSORA1..PCG.USR_CHANGEPASSWORD @.UserName ,@.Password ,@.PasswordNew ,@.PasswordCfm;
--Exec ( 'SANSORA1..PCG.USR_CHANGEPASSWORD (' + @.UserName + ' ,' + @.Password + ' ,' + @.PasswordNew + ' ,' + @.PasswordCfm + ')')
You would need to create a package wrapper and use openquery().Courtesy of Umachandar:
http://tinyurl.com/7dxrr|||
Thanks, found a solution:
declare @.sql varchar(3000)
set @.sql = 'CALL PCG.USR_CHANGEPASSWORD(''' + @.UserName + ''', ''' + @.Password + ''', ''' + @.PasswordNew + ''', ''' + @.PasswordCfm + ''')'
Exec (@.sql) at SANSORA1
