PLS-00222: no function with name 'ABC' exists in this scope

It's a little hard to tell without seeing any of your code...   but maybe you need to prefix the package/application wherein the procedure is defined — such as myapp.ABC (which would translate to something like myapp::ABC(...) on the Perl side).  Just a guess, though.

A generic hint whenever Oracle gets confused and throws ORA-xxxxx and PLS-xxxxx codes: Type the exact code including the ORA- or PLS-Prefix into Google and look at the first few results. They are often very helpful, even better than the huge load of Oracle's documentation.

ORA-06550 means that Oracle has found a syntax error in some PL/SQL code, PLS-00222 means PL/SQL function not found. The common webpages recommend to check the spelling. A common mistake seems to be that there is a PL/SQL procedure with the given name, but no function (yes, they are different).

It seems you ran into that trap: You talk about running your procedure from SQL Developer, but then instruct perl to invoke a function.

Alexander

Here is the Oracle procedure I'm trying to execute...This procedure is printing the output onto the screen. Is there anyway that i can get the output inform of rows from any CPAN Module

create or replace PROCEDURE abc AS
BEGIN
  DECLARE Tname user_tables.table_name%TYPE;
  Tstatus user_tables.status%TYPE;
  CURSOR data_groups IS
  SELECT table_name, status
  FROM user_tables;
BEGIN
  OPEN data_groups;
  FETCH data_groups
  INTO Tname, Tstatus;
  WHILE data_groups % FOUND
  LOOP
    DBMS_OUTPUT.PUT_LINE(Tname || ' ==> ' || Tstatus);
    FETCH data_groups
    INTO Tname, Tstatus;
  END LOOP;
END;
END abc;
[download]

Here is the Oracle procedure I'm trying to execute [...] create or replace PROCEDURE abc AS [...]

This is a PROCEDURE. In your first posting starting this thread, you tried to call it as a FUNCTION.

A FUNCTION is something else than a PROCEDURE. Functions must return values, procedures can not return anything. Assigning (or comparing) "the result" of a procedure is impossible, as there is no result, and there can't be one.

something:=someProcedure is invalid, Oracle told you that, and the Google results for "PLS-00222" would have told you that even more clearly. (And I told you that pretty clear, too.)

Alexander

--
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)

It appears that you are attempting to execute the PL/SQL block:

BEGIN
    ? := abc;
END;
[download]

That is attempting to call the function abc, not the proceudre abc, hence your error message. Try changing the PL/SQL to:

BEGIN
    abc;
END;
[download]

You have to call procedures in void context.

You have to call functions in non-void context.

If you do not want to rely on this mechanism, you can declare the correct type using the attributes :procedure and :function:

use DBIx::ProcedureCall qw[
  sysdate:function
  dbms_random.initialize:procedure
];
[download]