Home » SQL & PL/SQL » SQL & PL/SQL » pl/sql function
pl/sql function [message #1825] Mon, 03 June 2002 02:09 Go to next message
andy
Messages: 92
Registered: December 1999
Member
i have created a function to calculate a value based on information from queries of two different tables.

i was planning to use this function in a sql statement to include in a report, however sql doesnt let me use it, i get invalid column name error.

i tried select function(parm) from dual, but same error

anyone know of a workaround

thanks
Re: pl/sql function [message #1826 is a reply to message #1825] Mon, 03 June 2002 02:29 Go to previous messageGo to next message
andy
Messages: 92
Registered: December 1999
Member
its ok i worked out what was wrong
Re: pl/sql function [message #1828 is a reply to message #1825] Mon, 03 June 2002 02:52 Go to previous message
andy
Messages: 92
Registered: December 1999
Member
its ok i worked out what was wrong
Previous Topic: Re: Mutation Error for Update Trigger
Next Topic: Re: Can we use PL/SQL key words as Coloumn Names
Goto Forum:
  


Current Time: Thu Apr 18 18:12:29 CDT 2024