----- 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