From: | Thomas(dot)K(dot)Hill at t-online(dot)de (Thomas Hill) |
---|---|
To: | |
Subject: | [Pljava-dev] stuck with procedures having out parameters |
Date: | 2012-10-26 06:35:56 |
Message-ID: | 508A2F4C.5070101@t-online.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
Classpath isn't the problem as I have another function (part of the same
JAR file
uploaded into same schema) working. It must have to do with the method
declaration and/or the method parameter handling and signature. Have reworked
the function definition to explicitely include the method signature, i.e.
CREATE OR REPLACE FUNCTION rte."SP_getNextID"(OUT "iNextID" integer, IN
"vcIDName" character varying)
RETURNS integer AS
'allDatabasesPk.Procedures.SP_getNextID(int[], java.lang.String)'
Now the static method seems to be found. But when calling the function using
pgadmin and issuing a 'Select rte."SP_getNextID"('xy');' I am getting error
Too many parameters - expected 1
which I find confusing as I am only passing one parameter!?
Can someone please help here?
Note: if this goes through now, sorry for posting a new thread but trying to answer to existing previous thread did always lead to mail delivery errors.
From | Date | Subject | |
---|---|---|---|
Next Message | Hal Hildebrand | 2012-10-26 14:46:18 | [Pljava-dev] stuck with procedures having out parameters |
Previous Message | bruno | 2012-10-25 11:42:06 | [Pljava-dev] One more question today: Permision failure in Backend.java |