Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Visual FoxPro SQL pass-through functions
Message
 
À
02/12/1999 03:19:28
Yuri Myasnikov
Bank Menatep Spb., Chelyabinsk Dep.
Chelyabinsk, Russie
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00296852
Message ID:
00297998
Vues:
21
I'm not up on Oracle passing but... lose the ? in your param that you pass.

>= sqlexec(lnConnect,{"call test_proc(?cPar1, ?@cResult)"})


>Hi Stephen!
>
>Thank's for you answer me.
>I was big fools ... :)
>
>Why ODBC Oracle 7.3 does not allow
>to get importance from stored procedure ,
>but Microsoft ODBC this do allows ?
>.....
>cPar = '2'
>cResult = space(40)
>= sqlexec(lnConnect,{"call test_proc(?cPar1, ?@cResult)"})
>cResult is empty or have trush!
>
>The stored procedure Test_Proc
>
>procedure test_proc (
> Param1 in varchar2,
> Result out varchar2
> )
>as
>begin
> Result := to_char ( 2* to_number(Param1))
>end;
>
>When Microsoft ODBC cResult have correct value.
>
>Thank's.
>
>Yuri
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform