Hi Rebekha
I managed to call an Oracle stored procedure from MapBasic using the
following command:
Dim hdbc As Integer
Dim hstmt As Integer
hdbc = Server_Connect("ODBC", __ODBC_CONSTRING__)
hstmt = Server_Execute(hdbc, "begin <name of my stored procedure>;
end;")
It is a lot quicker as well
:)
Hope this helps because MapInfo Support sure weren't!!!!!!
They directed me here ;-)
Regards,
Stephen Syrett
Systems Software Engineer
Mobile Telecommunications Networks (MTN)
South Africa
NOTE: This e-mail message and all attachments thereto contain confidential information
intended for a specific addressee and purpose. If you are not the addressee (a) you
may not disclose, copy, distribute or take any action based on the contents hereof;
(b) kindly inform the sender immediately and destroy all copies hereof. Any copying,
publication or disclosure of this message, or part hereof, in any form whatsoever,
without the sender's express written consent, is prohibited. No opinion expressed or
implied by the sender necessarily constitutes the opinion of MTN. This message does
not constitute a guarantee or proof of the facts mentioned herein.
