AnsweredAssumed Answered

PL\SQL Package in AFX

Question asked by Tahir Ahmed on Apr 24, 2018
Latest reply on May 15, 2018 by Tahir Ahmed

Hello,

For AFX configuring for a application. Application Team provided pl\sql package, we need to execute below statements for provisioing/de-provisioning.

 

declare
v NUMBER;
v_msg VARCHAR2(200);
begin
temp_hr.iam_handling.CREATE_ACCOUNT ('TEST.IAM','123','1','TEST IAM','TEST IAM11111',v,v_msg);
DBMS_OUTPUT.PUT_LINE(v);
DBMS_OUTPUT.PUT_LINE(v_msg);
end;

Tried executing v Using Oracle connector, recieved below error.

 

Can someone confirm, is this supported OOTB or any other way we can implement this.

Outcomes