Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Visual FoxPro SQL pass-through functions
Message
From
02/12/1999 03:19:28
Yuri Myasnikov
Bank Menatep Spb., Chelyabinsk Dep.
Chelyabinsk, Russia
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00296852
Message ID:
00297795
Views:
21
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform