----- Original Message ----- From: Ricardo To: zope@zope.org Sent: Thursday, July 26, 2001 11:58 AM Subject: Z Stored Procedures help! Hi, I have created a packge in my oracleDB with a simple procedure to test and learn to use Z Stored Procedures. My packege and procedure works in Oracle ok. Here is the code: PACKAGE test_pkg IS PROCEDURE conta_reg; END; PACKAGE BODY TEST_PKG IS PROCEDURE conta_reg IS total NUMBER; BEGIN SELECT COUNT(*) INTO total FROM ASSUNTOS; END; END; Them I created in Zope a ZstoredProcedure object to test my procedure( initially it was a function that returned the value of total). After creation my ZstoredProcedure returned the message: "procedure TEST_PKG.CONTA_REG has arguments:" So it reconized the TEST_PKG.CONTA_REG in the oracle database. Then I decided to test the procedure call and pressed test and got the following error: (6550, 'ORA-06550: line 1, column 27:\012PLS-00103: Encountered the symbol ":" when expecting one of the following:\012\012 ( ) - + mod not null others \012 avg\012 count current exists max min prior sql stddev sum variance\012 cast \012 \012The symbol ":" was ignored.') Does anyone knows what is going on? Why ZstoredProcedure didn't call correctly the TEST_PKG.CONTA_REG in the oracle database? Any bug in ZstoredProcedure that I am not aware? Thanks Ricardo