David,

I havent tried this, but if you can issue an oracle sql out of MI that is 
passed directly to oracle,
a trick could be writing a function rather than a procedure.

Then do a

SELECT function_name(parameters) FROM DUAL;

out of MI. Disregard the result.

NB. Dual is a dummy table, you could use real tables instead was well.
Do whatever you like witjin your function.

Regards
Christof

PS: could you drop me a note it it worked?

-----Urspr�ngliche Nachricht-----
Von:    BERGER David, SETRA/CITS [SMTP:[EMAIL PROTECTED]]
Gesendet am:    Dienstag, 16. Oktober 2001 14:36
An:     '[EMAIL PROTECTED]'
Betreff:        MI-L Mapbasic and Oracle

Hello,

Does anyone know how to call a PL/SQL procedure on Oracle table from
MAPBASIC?
I'd like to use this on Oracle Spatial Tables.


Thank you for your help

David Berger



_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.



_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.

Reply via email to