Dear all, Because the SQL statement I wish to pass is far in excess of 255 characters, I have put it into a stored procedure. Now I am having a real problem calling the stored procedure.
I have tried: Server_Execute(ConnNum, "exec <procedurename>") but I am getting no joy as strictly speaking 'exec <procedurename>' is not a SQL statement. I have tried everything, please help if you know how to do this. I am using MapBasic/MI Pro 7.0, Oracle 9i. Thanks Bek Cruddace ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3585
