From: Graham <gandalfmeister@...>
Date: 2005-09-08T22:26:29+09:00
Subject: Banging head against the wall..

Quick question: I just need another set of eyes on this as I cannot see
what is wrong:-
sth = $dbh.prepare("select sal.isid, sal.access_level from
roles_dev.spig_access_list sal, filer_uncs stdy where
stdy.foldertype_qualifier=sal.spig_project and
stdy.foldertype_qualifier=? ")

when executed generates an error of
C:/ruby/lib/ruby/site_ruby/1.8/DBD/Oracle/Oracle.rb:384:in `parse':
ORA-01003: no statement parsed (DBI::DatabaseError)
	from C:/ruby/lib/ruby/site_ruby/1.8/DBD/Oracle/Oracle.rb:253:in
`initialize'
	from C:/ruby/lib/ruby/site_ruby/1.8/DBD/Oracle/Oracle.rb:124:in `new'
	from C:/ruby/lib/ruby/site_ruby/1.8/DBD/Oracle/Oracle.rb:124:in
`prepare'
	from C:/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:624:in `prepare'
	from U:/Ruby_progs/sync/sync.rb:179

However - if I comment out this block of code, and skip to the next
block of code which reads:
sth = $dbh.prepare("select isid from
table(ldap.find_by_department(?))")

... this works perfectly.
I cannot see any difference here. Can anyone see anything obvious?
Thx