Thanks someone gave the same answer on PROFOX mailing list - thanks again
Shawn
>I did not try with SPT but I did it successfully with ADO. Maybe you could try this :
>
>*************************************
>** Description of variables used **
>* h = handle
>* ORADSN = datasource name
>* USERID = user id
>* PWD = password
>**************************************
>
> h=SQLConnect("ORADSN","USERID","PWD") && Establish a connection
>
> IF h > 0
>
> WAIT WINDOW "Connection Successful" NOWAIT
> =SQLExec(h,"{Call SP_MYPROC}") && Execute the stored procedure
> =SQLDisconnect(h) && Terminate the connection
>
> ELSE
>
> WAIT WINDOW "Connection Failed"
>
> ENDIF
>I found it on MSDN.
>
>HTH,
>Christian Cote