Hi,
I have written a procedure like below.
TYPE GENERAL IS VARRAY (100) OF VARCHAR2(1000);
PROCEDURE GET_GENERAL_INFO
(i_quote_header_id IN NUMBER,
O_LINE_ID_GEN OUT GENERAL,
O_LINE_GENERAL_INFO OUT GENERAL)
IS
V_LINE_ID_GEN NUMBER;
V_LINE_GENERAL VARCHAR2(4000);
LINE_ID_GEN GENERAL := GENERAL();
LINE_GENERAL_INFO GENERAL := GENERAL();
CURSOR general_info IS
select
main_line.QUOTE_LINE_ID,
MTL_SYSTEM_ITEMS_TL.LONG_D
ESCRIPTION
from
ASO_QUOTE_LINES_ALL main_line,
MTL_SYSTEM_ITEMS_TL
where
QUOTE_HEADER_ID = i_quote_header_id--41332
AND main_line.LINE_NUMBER = 40000
AND main_line.LINE_LIST_PRICE <>0
AND main_line.ORGANIZATION_ID = MTL_SYSTEM_ITEMS_TL.ORGANI
ZATION_ID
AND main_line.INVENTORY_ITEM_I
D = MTL_SYSTEM_ITEMS_TL.INVENT
ORY_ITEM_I
D
AND NVL(MTL_SYSTEM_ITEMS_TL.LA
NGUAGE,use
renv('LANG
')) = userenv('LANG');
BEGIN
OPEN general_info;
LOOP
FETCH general_info INTO V_LINE_ID_GEN, V_LINE_GENERAL;
DBMS_OUTPUT.PUT_LINE(V_LIN
E_ID_GEN||
' '||V_LINE_GENERAL);
EXIT WHEN general_info%NOTFOUND;
LINE_ID_GEN.extend;
LINE_ID_GEN(LINE_ID_GEN.co
unt) := V_LINE_ID_GEN;
LINE_GENERAL_INFO.extend;
LINE_GENERAL_INFO(LINE_GEN
ERAL_INFO.
count) := V_LINE_GENERAL;
END LOOP;
CLOSE general_info;
O_LINE_ID_GEN := LINE_ID_GEN;
O_LINE_GENERAL_INFO := LINE_GENERAL_INFO;
END GET_GENERAL_INFO;
When i call this by using the following code
SET SERVEROUTPUT ON
variable g_line_id NUMBER;
variable g_gen VARCHAR2(4000);
exec XXIBE_VA_QUOTE_PRINT_PKG.G
ET_GENERAL
_INFO(4133
2, :g_line_id, :g_gen);
print g_line_id
print g_gen
The error is coming like the following:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GET_GENERAL_INFO'
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GET_GENERAL_INFO'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
What is the reason? Please let me know the solution for this
Start Free Trial
