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