Solved

How to use callback function with plsql_rest_sender_api.call_rest_endpoint?

  • 4 August 2023
  • 1 reply
  • 377 views
hhy38
Rank
Userlevel 5
Badge +14
  • hhy38
  • Hero (Customer)
  • 275 replies

Hi,

 

With plsql_rest_sender_api.call_rest_endpoint_empty_body I can send the response to the callback function. However, I couldn’t do it with “plsql_rest_sender_api.call_rest_endpoint”. The common callback function returns an error in the second chain of the routing rule. Is it possible?

 

Caused by: oracle.jdbc.OracleDatabaseException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'REST_CALLBACK_TEST'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "IFSAPP.PLSQL_REST_SENDER_API", line 124
ORA-06512: at "IFSAPP.PLSQL_REST_SENDER_API", line 133
ORA-06512: at line 1

 

icon

Best answer by hhy38 7 August 2023, 16:37

View original
Linkedin Profile: https://www.linkedin.com/in/hhy34/

1 reply

hhy38
Rank
Userlevel 5
Badge +14

Yes, it is possible. I checked the “plsql_rest_sender_API.REST_Common_Callback” procedure. There was a problem with arguments. After that, I added key_ref_ and fnd_user_ arguments to use in the callback function. Now it is transferring response.

 

The Request

REST_Common_Callback (It will use :result, :app_msg_id, :fnd_user, :key_ref as argument to call actual callback function)

Actual Callback 

Response Table

Application Message

 

Linkedin Profile: https://www.linkedin.com/in/hhy34/

Reply


Terms & ConditionsCookie settings