Re: Funky Error during select.
Posted by: Chris Cline
Date: November 03, 2004 01:35PM

Sorry for the post but I found the cause of the original error I posted.

If I remove the single-quotes from the 05 and 2004 I do not get any errors and values are returned. This is with cYear and cMonth being VarChar(4) and Char(2).

Unless I should be using double-quotes instead of single I can only assume it something with the sql parser.

hope this helps.

Options: ReplyQuote

Written By
November 03, 2004 12:34PM
November 03, 2004 01:20PM
November 03, 2004 01:28PM
Re: Funky Error during select.
November 03, 2004 01:35PM

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.