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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Feb 22 15:39:53 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.