Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00904: "ISNULL":invalid Identifier
ORA-00904: "ISNULL":invalid Identifier [message #252691] Thu, 19 July 2007 12:27 Go to next message
bigpapi
Messages: 6
Registered: June 2007
Junior Member
I am getting the following error ORA-00904: "ISNULL":invalid Identifier on the below line of code.

The code is from a powerbuilder application.


				Substring( customer_alias.cust_alias_last_name + ',', Sign( Charindex( ',', customer_alias.cust_alias_last_name + ',' ) -1), Charindex( ',', customer_alias.cust_alias_last_name + ',' ) ) + IsNUll(Customer_alias.cust_alias_first_name, '') + IsNull(customer_alias.cust_alias_middle_name, '') "Mail Name",



What can i do to make this code work????



thanks in advance
Re: ORA-00904: "ISNULL":invalid Identifier [message #252695 is a reply to message #252691] Thu, 19 July 2007 12:36 Go to previous message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
>What can i do to make this code work????
Stop using SQL Server functions & only use Oracle functions.

Please learn how to format your posts byfollowing guideline in STICKY post at top of this forum.
Previous Topic: Mass update of column for all rows
Next Topic: dbms_scheduler
Goto Forum:
  


Current Time: Tue Dec 06 14:02:56 CST 2016

Total time taken to generate the page: 0.10538 seconds