How to convert Java function to postgresql function

Question

I have oracle function which I want to convert into PostgreSQL below I am mentioning the oracle function.

create or replace
FUNCTION             "BOMQTYON" (M_Product_ID NUMBER, M_Warehouse_ID NUMBER,
        M_Locator_ID NUMBER, LocatorType VARCHAR2)
    RETURN NUMBER
    AS LANGUAGE JAVA
    NAME 'org.compare.sqlj.Product.bomQtyOnHold(int,int,int,java.lang.String) return java.math.BigDecimal';

I tried to create a function in PostgreSQL but it given me error on language JAVA does not exists

Please post what you tried so far and the problems you are having — Aleksej
– Aleksej, Commented Aug 9, 2016 at 12:49

Laurenz Albe · Accepted Answer · 2016-08-09 13:59:23Z

1

You will have to rewrite your function in one of the server programming languages on PostgreSQL.

Apart from the usual suspects PL/pgSQL and PL/Perl, you could consider using PL/Java, but you'll have to build it yourself, and don't expect that you can just reuse your Oracle code without modifications.

answered Aug 9, 2016 at 13:59

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Lina Over a year ago

I tried to create PL java language but it s not showing in drop down list please suggest me how can i create PL/java

Laurenz Albe Over a year ago

I have no idea what drop-down list you are talking about. What program has this drop-down list? About installation: did you follow the instructions? With what success?

Collectives™ on Stack Overflow

How to convert Java function to postgresql function

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related