Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Call SQL Server stored procedure from sqlplus

Status
Not open for further replies.
JtheRipper

JtheRipper

IS-IT--Management
Oct 4, 2002
274
GB
Hi there,

I successfully set up a connection to a SQL Server database from Oracle using Oracle's transparent gateway. I can query tables, but I want to know if I can execute a procedure on SQL Server FROM sqlplus via the transparent gateway.

Any ideas?

Thanks,
J.
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
1K
Andrzejek
Andrzejek
unixfreak
  • Locked
  • Question
sqlplus backspace through 'screen'
Replies
1
Views
319
Samthyr
Samthyr
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
6K
carp
carp
Andrzejek
  • Locked
  • Question
Show value from DATA_DEFAULT field 1
Replies
2
Views
1K
Andrzejek
Andrzejek
annie1975
  • Locked
  • Question
sql script in an cron job script failing
Replies
3
Views
510
carp
carp

Part and Inventory Search

Sponsor

Back
Top