Solved

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

  • 26 April 2022
  • 2 replies
  • 352 views

Badge +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?

icon

Best answer by Kelum Pradeep Kumara 26 April 2022, 17:22

View original

2 replies

Userlevel 7
Badge +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
 

Userlevel 4
Badge +8

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

Reply