> Hi Evgeny Putilin,
>
> Thanks for reply. I want to call java program from stored
> prcedure or trigger. I am using firebird 2.1.3, is this alpha version? if yes
> then can you please guide me with example.

No Firebird 2.1.3 is the latest release version. The FB/Java plugin only works in Firebird 3.0, an experimental version, including a 32 bit Firebird 3.0 server is available at http://www.firebirdsql.org/index.php?op=devel&sub=plugins&id=external_java

This is very experimental, so don't use it for production work. Questions should most likely be addressed to the firebird-devel mailinglist.

Mark

>
> CREATE PROCEDURE add_emp (
> senderid NUMBER, recepientno NUMBER, mes VARCHAR2)
> AS LANGUAGE JAVA
> NAME 'DBTrigger.addEmp(int, int, java.lang.String)';
>
> when i am executing this query getting below error.
>
> Engine Error (code = 335544569):
> Dynamic SQL Error.
> SQL error code = -104.
> Token unknown - line 3, column 4.
> LANGUAGE.
>
> SQL Error (code = -104):
> Invalid token.
>
> Please guide me.

This functionality is not available in Firebird 2.1.3
--
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01