[cl-debian] Bug#481029: cl-sql-oracle fails to connect to oracle database

[Kevin Rosenberg]

Paul Metcalfe wrote:
> debugger invoked on a TYPE-ERROR in thread #<THREAD "initial thread" 
> {100270AC31}>:
>   The value
>     #<SB-ALIEN-INTERNALS:ALIEN-VALUE :SAP #X006A2400 :TYPE (* (SIGNED 
> 16))>
>   is not of type
>     (ALIEN (ARRAY (SIGNED 16) NIL)).
> 
> This seems to be caused by the type declarations in fetch-row
> (in oracle-sql.lisp); if I comment them all out I can connect 
> and fetch data happily (in a very limited test).
> 

> Is this the same problem as
> http://lists.b9.com/pipermail/clsql/2008-April/001576.html

It seems so.

> [ and is this a cl-sql-oracle problem or a cl-uffi problem? ]

I don't know. I don't have an Oracle system for testing so I'm unable
to further characterize the issue. I do know those those type
declarations for SBCL's FFI can be crucial to have in place or
performance can be quite impacted. 

Kevin