Graham wrote:
> 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

Maybe it's not in the SQL put in the process.  Do you have any cursors or
whatever open when you issue the #prepare?  Also the second SQL looks
quite strange to me.  Not that it would explain why the second call works
but is this really valid Oracle SQL?

Kind regards

    robert