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