Re: Stored Procedures / Functions

This solved my problem:

You can't execute a function in the same way as a procedure. You have to wrap it up in a select.

        select get_hh_point(80) from dual;

will work.

Jussi

Jussi Peltonen wrote:
>
> 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]
 

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