Oracle problems

Matthew Zeits <[email protected]> Mon, 28 Feb 2011 12:36:08 -0500
Newsgroups gmane.lisp.clsql.general
Message-ID <[email protected]>
Having difficulty running queries on an existing oracle database:

I can run from sqlplus and get results logged in as the user.  I logged in
and had success:

(clsql:connect `("desiree" "coma" "*********") :database-type :oracle)

#<CLSQL-ORACLE:ORACLE-DATABASE desiree/coma OPEN {581C3005}>

but running a query that I can run from sqlplus gives this:

(clsql:query "select distinct(message_type) from messagetable where
simulationindex=1361")


A database error occurred on database #<ORACLE-DATABASE desiree/coma OPEN
                                        {592C8855}>: 24909 / NIL
  ????????????????????????????

   [Condition of type CLSQL-SYS:SQL-DATABASE-ERROR]

Restarts:
  0: [ABORT] Return to Top-Level.

Debug  (type H for help)

(CLSQL-ORACLE::HANDLE-OCI-ERROR
 :DATABASE #<CLSQL-ORACLE:ORACLE-DATABASE desiree/coma OPEN {592C8855}>
 :NULLS-OK NIL)
Source: Error finding source: Type-error in
KERNEL::OBJECT-NOT-TYPE-ERROR-HANDLER:
                                 NIL is not of type STREAM

_______________________________________________
CLSQL mailing list
[email protected]
http://lists.b9.com/cgi-bin/mailman/listinfo/clsql