Re: Stored Procedure
In ...where (PublishDate > @SBlogDate and PublishDate < @EBlogDate)..., @sblogdate and @eblogdate refer to user variables set before the sproc was called, not to your sblogdate and eblogdate params. To refer to those param values, lose the @ prefixes.
And for correct comparisons, those params should be the same type as the columns they're being compared with.
Subject
Views
Written By
Posted
2656
November 08, 2015 08:28AM
877
November 08, 2015 08:35AM
Re: Stored Procedure
880
November 08, 2015 12:48PM
788
November 08, 2015 04:45PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.