Groups > comp.lang.java.databases > #274

Re: java.sql.SQLException

Path	csiph.com!x330-a1.tempe.blueboxinc.net!feeder1.hal-mli.net!news.glorb.com!news-out.readnews.com!news-xxxfer.readnews.com!news-out.news.tds.net!newsreading01.news.tds.net!86597e80!not-for-mail
From	joeNOSPAM@BEA.com.remove-dii-this
Subject	Re: java.sql.SQLException
Message-ID	<bbca984c-8395-42a6-95a2-8872648a0ca2@a70g2000hsh.googlegroups.com> (permalink)
X-Comment-To	comp.lang.java.databases
Newsgroups	comp.lang.java.databases
In-Reply-To	<afc53c72-9ca4-42cb-b652-1b6203d2d928@59g200
References	<afc53c72-9ca4-42cb-b652-1b6203d2d928@59g200
Content-Type	text/plain; charset=IBM437
Content-Transfer-Encoding	8bit
X-Gateway	time.synchro.net [Synchronet 3.15a-Win32 NewsLink 1.92]
Lines	23
Date	Wed, 27 Apr 2011 15:22:47 GMT
NNTP-Posting-Host	96.60.20.240
X-Complaints-To	news@tds.net
X-Trace	newsreading01.news.tds.net 1303917767 96.60.20.240 (Wed, 27 Apr 2011 10:22:47 CDT)
NNTP-Posting-Date	Wed, 27 Apr 2011 10:22:47 CDT
Organization	TDS.net
Xref	x330-a1.tempe.blueboxinc.net comp.lang.java.databases:274

Show key headers only | View raw

  To: comp.lang.java.databases
On Oct 3, 8:19=A0am, laredotornado <laredotorn...@zipmail.com> wrote:
> Hi,
>
> I'm using Java 1.5 with WebLogic 9.2.2 connected to an Oracle 10 db.
> I'm getting the below error but what is odd is that I can run the
> offending SQL statement fine using PL/SQL Developer. =A0I have verified
> that the connection information is the same. =A0Any way to tell exactly
> what is the "Invalid identifier"?
>
> Thanks, - Dave
>
> java.sql.SQLException: ORA-00904: "NPS_LOG"."PKG_NPSLOG"."GET_LKUP":
> invalid identifier

Hi. Show the SQL and the JDBC code that sets the parameters and the
parameter values, and maybe the DDL of the table(s) being queried.
Joe Weinstein

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24

Back to comp.lang.java.databases | Previous | Next | Find similar

Thread

Re: java.sql.SQLException joeNOSPAM@BEA.com.remove-dii-this - 2011-04-27 15:22 +0000

csiph-web