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>


"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/slatteryt
Received on Tue Aug 19 2008 - 11:31:47 CDT

Original text of this message