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]?


>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)