Steve Berger
asked on
What is mean by this error message?
Hi,
When i run the below PL/SQL block i am getting ORA-24334: no descriptor for this position error.
set serveroutput on
DECLARE
g_line_id sample_pkg_1.FND_TABLE_OF_ VARCHAR2_4 000 := sample_pkg_1.FND_TABLE_OF_ VARCHAR2_4 000 ();
g_gen sample_pkg_1.FND_TABLE_OF_ VARCHAR2_4 000 := sample_pkg_1.FND_TABLE_OF_ VARCHAR2_4 000 ();
BEGIN
sample_pkg_1.get_info (6674, g_line_id, g_gen);
FOR i IN 1 .. g_line_id.COUNT
LOOP
DBMS_OUTPUT.put_line ('g_line_id(' || i || '): ' || g_line_id (i));
END LOOP;
FOR i IN 1 .. g_gen.COUNT
LOOP
DBMS_OUTPUT.put_line ('g_gen(' || i || '): ' || g_gen (i));
END LOOP;
END;
Can you anyone share with me about the reason of this error?
Thanks
When i run the below PL/SQL block i am getting ORA-24334: no descriptor for this position error.
set serveroutput on
DECLARE
g_line_id sample_pkg_1.FND_TABLE_OF_
g_gen sample_pkg_1.FND_TABLE_OF_
BEGIN
sample_pkg_1.get_info (6674, g_line_id, g_gen);
FOR i IN 1 .. g_line_id.COUNT
LOOP
DBMS_OUTPUT.put_line ('g_line_id(' || i || '): ' || g_line_id (i));
END LOOP;
FOR i IN 1 .. g_gen.COUNT
LOOP
DBMS_OUTPUT.put_line ('g_gen(' || i || '): ' || g_gen (i));
END LOOP;
END;
Can you anyone share with me about the reason of this error?
Thanks
ASKER
No i am using array with in package. That's what i am calling the package in this way.
This is neither a package nor a procedure.
This is PL/SQL anonymous block.
This is PL/SQL anonymous block.
ASKER
No i have created the package with name of sample_pkg_1. And get_info is the procedure with in that package. I am calling this package from anonymous block. Because i am using Array in the package. That's what i am invoking the package through this way.
If you are using array in a package it should be declared firstly as type.
Even outside the package.
If you do not do this you will have error messages.
And this happens ...
Even outside the package.
If you do not do this you will have error messages.
And this happens ...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As I recall this what you declary has local scope - only in the package.
The type is unknown outside the package.
To use it outside the package you have to declare it at schema level.
The type is unknown outside the package.
To use it outside the package you have to declare it at schema level.
sample_pkg_1.FND_TABLE_OF_
You can use type clause instead