Re: Passing value from table into variable.

From: Ewa M. <knowacz_at_usa.net>
Date: 1998/04/20
Message-ID: <353B7BE1.1DF5_at_usa.net>#1/1

Graham Miller wrote:

> Hello Eva,
> The Oracle error message says it all. Your query returns a character
> string but you have told it to expect a date.
> Either: Procedure PROC_A (control_date in out VARCHAR2)
>
> or: Return a date from the query and test for null value in the
> calling program.

Graham,
thanks a million! Your hint was so useful that I don't have trouble with procedures and functions with parameters right now and can advance my work.
Have a good week!
Greetings,

Eva Maciasz,
McGill University,
Montreal, Canada. Received on Mon Apr 20 1998 - 00:00:00 CEST

This message: [ Message body ]
Next message: DanHW: "Re: Forms 4.5 - Check the presence of a field"
Previous message: rono_at_fl.envworld.com: "Re: Your opinions of Designer 2000??"
Maybe in reply to: Eva M.: "Passing value from table into variable."
In reply to Eva M.: "Passing value from table into variable."
Next in thread: DanHW: "Re: Forms 4.5 - Check the presence of a field"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message