Re: PL/SQL Problem

Hi

> No, you do not have to use it. Just put anything you want to declare
between
> the AS (or IS) and BEGIN:
>
> create or replace function get_allcmd(pnumcom commande.numcom%TYPE)
return tcmd as
> type tcmd is record
> ( tnumtable numtable%TYPE,
> tnumserv numserv%TYPE,
> tnomserv nomserv%TYPE,
> tdatecom DATE,
> tmontant montant%TYPE);
> rcmd tcmd
> begin
> ...
> end;

It doesn't work. Here is the error message. Can't use a type that is declared after. Any idea?

Sydney Received on Tue May 11 1999 - 11:59:04 CDT