| Can Oracle Forms call a SQL Server 2000 Stored Proceure? [message #78414] |
Thu, 21 February 2002 16:34  |
paul fell
Messages: 2
Registered: February 2002
|
Junior Member |
|
|
Hi have a form that connects to SQL Server 2000 using ODBC. I can get data into the form DATA BLOCK ok using SELECT. Now I'm experimenting with a button press to execute a SQL Server 2000 Stored Procedure.
I've tried exec my_proc(parameter list) but I keep getting 'syntax error near my_proc' when I try to compile.
Any suggestions. The SP works OK in SQL Server :)
Don't ask me why I want to connect Oracle Forms to SQL Server 2000..... it's a long story
Paul
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
