Hi Jeff,
I've called stored procedures with MS SQL Server. I think Oracle will be the same.
x = sqlconnect() && login to your database
y = sqlexec(x,'oracle_stored_proc_name '+m.parm_one)
Where m.parm_one is the vfp mem var you want to pass to Oracle.
Also you can build complete sql statements in a vfp memo field, ex. field name 'sql_code' and send the whole bunch to Oracle.
y = sqlexec(x,sql_code)
If y < 0 , check out errors by using aerror().
Gook luck,
Paul
>Hi all,
>
>We're trying to call an Oracle stored procedure from VFP and pass it parameters and get back a result set via SQL pass-through (SQLExec function). Has anyone done this succesfully and could share their syntax with me? The version of Oracle we're using is 7.3.2.1 running on UNIX and VFP 6.0 running on NT/Novell.
>
>We've succesfully implemented SQL pass-through and views for getting at Oracle tables but this stored procedure thing looks to be a bit more involved.
>
>Thanks for any and all help and happy holidays!
>
>-JT
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement