Re: Procedure builder problem

From: Guenter Huerkamp <guenter-huerkamp_at_t-online.de>
Date: Fri, 24 Mar 2000 16:35:08 +0100
Message-ID: <38DB8B2C.4AF1E362@t-online.de>

Hello Moore
I think get_test is a function not a procedure, therefor you must declare a variable and return the returnvalue to the variable. Günter

Moore schrieb:

> What am I doing wrong?
>
> Is it possible to debug a function?
>
> PL/SQL> ALTER Function "GET_TEST" COMPILE;
> PL/SQL> .break PROGRAMUNIT UIMSMGR.GET_TEST LINE 8 ENABLED
> Breakpoint #2 installed at line 8 of GET_TEST
> PL/SQL> GET_TEST(22, 23);
> ERROR 221 at line 1, column 1
> 'GET_TEST' is not a procedure or is undefined
> ERROR 0 at line 1, column 1
> Statement ignored
> PL/SQL> UIMSMGR.GET_TEST(22, 23);
> ERROR 221 at line 1, column 1
> 'GET_TEST' is not a procedure or is undefined
> ERROR 0 at line 1, column 1
> Statement ignored

Dipl.-Inform. Günter Huerkamp

Web : http://gh.notrix.de

privat     : mailto:guenter-huerkamp_at_t-online.de
privat     : mailto:guenter-huerkamp_at_web.de
dienstlich : mailto:Guenter.Huerkamp_at_lk-wl.nrw.de


---------------------------------------------------------------

Received on Fri Mar 24 2000 - 09:35:08 CST