Hi Rebekah, There's no 255 character limit when using Server_Execute with MS/SQL (2K with MIPro 6.5), so I don't think there is with Oracle either. If you build a query string to submit, the limit's 32K. And that does apply, I've hit my head on it several times :-)
I haven't tried to execute stored procedures in MS/SQL, and I'm not sure it works. Server_Execute sends one query and returns one result set (hStmt), but a stored procedure may return any number (0 or more) of seperate result sets. So there's an implicit logical problem. Best regards / Med venlig hilsen Lars V. Nielsen Odense, Denmark ----- Original Message ----- From: "Rebekah Boott" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 15, 2002 5:38 PM Subject: MI-L Calling Oracle stored procedures from MapBasic > 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 > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3591
