[prev in list] [next in list] [prev in thread] [next in thread] 

List:       xml-cocoon-users
Subject:    Strange behavior in SQLTransforme Cocoon 2.0.3
From:       "Luca Morandini" <luca.morandini1 () tin ! it>
Date:       2002-09-30 21:46:50
[Download RAW message or body]

Folks,

when I call an Oracle Stored Procedure with SQLTransformer the DBMS refuses to \
execute it (lamenting a parsing error) if I don't put the call on one line.

Needless to say, it worked fine up to 2.0.2.

My configuration:
- Windows 2000 Pro SP3
- JDK 1.3.1
- Tomcat 4.0.1
- Cocoon 2.0.3
- Oracle 8.1.7

To sum it up:

begin UMan.Logon('ammini', 'ammini', ?, ?, ?, ?, ?); end;

works

begin UMan.Logon('ammini',
'ammini', ?, ?, ?, ?, ?); end;

doesn't... it gives:
ERROR   (2002-09-30) 23:37.34:339   [sql.transformer.sql] \
(/cerbero-dev/login-execute.html) Ajp13Processor[8009][4]/SQLTransformer$Query: \
                Caught a SQLException
java.sql.SQLException: ORA-06550: riga 1, colonna 27:
PLS-00103: ...

Best regards,

---------------------------------------------
               Luca Morandini
               GIS Consultant
              lmorandini@ieee.org
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------



---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


[prev in list] [next in list] [prev in thread] [next in thread]