Re: Stored Procedures / Functions

From: Iken Sen <m-33785_at_mailbox.swipnet.se>
Date: 1999/04/03
Message-ID: <LgvN2.2105$x43.3091_at_nntpserver.swip.net>#1/1


If you use function, normally just one OUT is outputed, I do this by using:

select SF(av) from dual;

Definitely, you can use OUT in function inside package.

dr Yigen Zeng, Sweden

In article <36FF14E0.CEF50E37_at_syscon-automation.fi>, jussi.peltonen_at_syscon-automation.fi says...
>
>I'm trying to use stored procedures and functions through ADO & ODBC.
>I've managed to call my test procedure as 'begin set_hh_point (80,80);
>end;' and it works fine. Is there a way to call stored function (or
>procedure with OUT parameter) through ODBC? The following message is
>returned when trying to execute 'begin get_hh_point (80); end;'
>statement.
>
>[Microsoft][ODBC driver for Oracle][Oracle]ORA-06550: line 1, column 7:
>PLS-00221: 'GET_HH_POINT' is not a procedure or is undefined
>ORA-06550: line 1, column 7:
>PL/SQL: Statement ignored
>
>Please, help.
>
>Jussi
>
>Tools:
>Oracle 8.0.5
>NT 4
>MS VC++ 6.0
>ADO 2
>
>
>--
>If you pick up a starving dog and make him prosperous, he will not bite
>you. This is the principal difference between a dog and a man. -Mark
>Twain
>[Puddin'head Wilson]
Received on Sat Apr 03 1999 - 00:00:00 CEST

Original text of this message