Hi,
I have a function with below definition:
CREATE OR REPLACE FUNCTION onesam.batchprint_individual(
p1 character varying,
p2 character varying,
p3 character varying,
p4 boolean,
p5 boolean,
p6 character varying,
p7 integer,
p8 integer)
RETURNS integer
LANGUAGE 'javau'
COST 100
VOLATILE PARALLEL UNSAFE
AS $BODY$
batchprint.Batch.individual(java.lang.String, java.lang.String, java.lang.String, java.lang.Boolean, java.lang.Boolean, java.lang.String, java.lang.Integer, java.lang.Integer)
$BODY$;
p1 character varying,
p2 character varying,
p3 character varying,
p4 boolean,
p5 boolean,
p6 character varying,
p7 integer,
p8 integer)
RETURNS integer
LANGUAGE 'javau'
COST 100
VOLATILE PARALLEL UNSAFE
AS $BODY$
batchprint.Batch.individual(java.lang.String, java.lang.String, java.lang.String, java.lang.Boolean, java.lang.Boolean, java.lang.String, java.lang.Integer, java.lang.Integer)
$BODY$;
And I am trying to execute below query:
SELECT batchprint_INDIVIDUAL(
'96674538',
'',
'',
't',
'f',
'UsysOfficial',
'1103003',
'1020')
'96674538',
'',
'',
't',
'f',
'UsysOfficial',
'1103003',
'1020')
and the ERROR I am getting is:
ERROR: java.lang.ClassNotFoundException: batchprint.Batch
SQL state: XX000
My postgres version is 11.14.
Could anyone suggest any kind of solution for it, as I couldn't find anything informative from a database perspective.
Regards,
Atul