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.
Not sure if it's supported.
Have you considered placing the commands in a stored procedure and then calling the stored procedure from the connector?