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 )


Re: Stored Procedure Problems [message #370206 is a reply to message #370204] Thu, 05 November 1998 10:15 Go to previous message
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


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

Current Time: Sun Nov 27 19:10:03 CST 2022