Re: Beginning SQL statements with a parenthesis in JDBC

[Ed Elud <edelud@yahoo.com>]

Prepared statements are your best bet.  It creates a
temporary stored proc on your db, even if you're not
sending parameters.  I've created sql with multiple
nested tables, and temp tables created within the from
clause and where clause - 200 lines long (please do
ask me what for --) ) , and successfully passed it
without problems through jdbc to Oracle.


--- Curt Smith <chsmith@speakeasy.net> wrote:
> This is not substiantive help, but I have trouble
> shot SQL that failed 
> in criptic
> ways through JDBC that worked perfect via sqlplus,
> toad and sqlnavigator.
> 
> I just subdivided the sql or simplified (or just
> fidled with it) till it 
> worked via
> my JDBC driver and DB.   I had troubles with nested
> selects (3 deep) etc.
> 
> My hearts to ya, man!   Good luck and let us know
> what worked.
> 
> yours,  curt
> 
> 
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com