Home » RDBMS Server » Server Administration » Re: Stored Procedure Problems
Re: Stored Procedure Problems [message #370204] Thu, 05 November 1998 06:21 Go to next message
Vijay Nimse
Messages: 4
Registered: November 1998
Junior Member
and b.swcustomerid like nvl(Cust,'%')

Change above statement with following
and ( Cust is null or b.swcustomerid = Cust )

Cheers

Vijay
Re: Stored Procedure Problems [message #370206 is a reply to message #370204] Thu, 05 November 1998 10:15 Go to previous message
Dony
Messages: 3
Registered: August 1998
Junior Member
try replacing this statement with your nvl
nvl(cust, b.swcustomerid);

Do let us know whether it really helped you

Cheers

Dony
Previous Topic: New ORACLE discussion board
Next Topic: Re: DBMS_ALERTS
Goto Forum:
  


Current Time: Fri Oct 23 16:46:51 CDT 2020