Re: Invalid character???
From: Tim Slattery <Slattery_T_at_bls.gov>
Date: Tue, 19 Aug 2008 12:31:47 -0400
Message-ID: <b2tla4d98b24t47dr7ui6l5okejk20jiei@4ax.com>
Date: Tue, 19 Aug 2008 12:31:47 -0400
Message-ID: <b2tla4d98b24t47dr7ui6l5okejk20jiei@4ax.com>
"Vladimir M. Zakharychev" <vladimir.zakharychev_at_gmail.com> wrote:
>Shouldn't this be spName = "{ ?= call getReporterData(?) }"; ? At
>least if you're using JDBC escape syntax... Otherwise it can be spName
>= "BEGIN ? := getReporterData(?); END;", in this case it'll be Oracle-
>specific.
I don't think so, I have ample documentation for :=. And I've tried it without the colon and gotten the same result.
FWIW, I've tried the Oracle syntax (begin...end) and also gotten an error: expression is of wrong type. I don't understand that one either.
-- Tim Slattery Slattery_T_at_bls.gov http://members.cox.net/slatterytReceived on Tue Aug 19 2008 - 11:31:47 CDT