>Modify your test code so you can get the error message of why it failed. You could post that here so someone may be able to better help you. The problem is not the SQLExec command. The problem probably is with your SP. What happens if you execute the SP from SQL*Plus? Do you get an error when the SP compiled [when you created the SP]?
Mark,
The stored procedure runs without problem from the SQL*Plus command line. Meanwhile, SQLExec() returns a negative value. Based on the sample in the Q114787 thread in MSDN site, I've also setup the following SQLSetProp() values:
sqlsetprop(x,'Asynchronous',.f.)
sqlsetprop(x,'BatchMode',.t.)
sqlsetprop(x,'ConnectTimeOut',0)
sqlsetprop(x,'Transactions',1)
With or without these settings; SQLExec() still returns a negative value.
Ramil 7/11
>
>
>>Hi,
>>I want to call Oracle stored procedures. My code goes like this but does not work.
>>iConn = sqlconnect()
>>if iConn > 0
>> iErr = sqlexec(iConn,'execute test.sp_test_call;')
>> if Err > 0
>> wait window 'Stored procedure successful'
>> else
> lnRetVal = aerror(laError)
> clear
> list memo like laErr*
>> wait window 'Stored procedure not successful'
>> endif
>>endif
>>sqldisconnect(iConn)
ramil
~~ learning to stand still