Skip to main content
Solved

Error: ORA-06508: PL/SQL: could not find program unit being called


Forum|alt.badge.img+1

I’ve created BizAPI and custom API for import XML file.

The custom API will call Register PO Receive standard procedure

(ex. Receive_Purchase_Order_API.Packed_Arrival__).

 

After I put the XML file in filerep1\<instance>\in folder, the file is imported correctly.

But the custom API raise error “Error: ORA-06508: PL/SQL: could not find program unit being called” when call other module’s standard procedure. 

I’ve tried re-execute the same procedure which is called in custom API via PL/SQL command with different users (ifsapp, ifsconnect, granted users), the error is not found and can be processed correctly.

 

Could you please suggest me to resolve this problem correctly?

Best answer by Kelum Pradeep Kumara

please try this
SQL> grant execute on utl_http to public;

Bit Similar discussion on below community thread
ORA-20000: Oracle Text error: DRG-50857: oracle error in drvddl.IndexSync ORA-06508: PL/SQL: could not find program unit being called ORA-06512 | IFS Community
 

View original

Kelum Pradeep Kumara
Superhero (Employee)
Forum|alt.badge.img+18

please try this
SQL> grant execute on utl_http to public;

Bit Similar discussion on below community thread
ORA-20000: Oracle Text error: DRG-50857: oracle error in drvddl.IndexSync ORA-06508: PL/SQL: could not find program unit being called ORA-06512 | IFS Community
 


Forum|alt.badge.img+8

@anphan Did this resolve your error? I have a similar situation on hands at the moment.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings