Home » Developer & Programmer » Forms » Can Oracle Forms call a SQL Server 2000 Stored Proceure?
Can Oracle Forms call a SQL Server 2000 Stored Proceure? [message #78414] Thu, 21 February 2002 16:34 Go to next message
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
Re: Can Oracle Forms call a SQL Server 2000 Stored Proceure? [message #78440 is a reply to message #78414] Mon, 25 February 2002 01:25 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
try
my_proc(parameter list);

instead of
exec my_proc(parameter list);
Re: Can Oracle Forms call a SQL Server 2000 Stored Proceure? [message #78458 is a reply to message #78440] Mon, 25 February 2002 14:16 Go to previous message
paul fell
Messages: 2
Registered: February 2002
Junior Member
Nope. If I do that I get "*Plus Internal error"

Paul
Previous Topic: Re: Oracle Forms
Next Topic: Re: I'm looking for free download of Developer 2000
Goto Forum:
  


Current Time: Tue Jul 07 05:38:27 CDT 2020