|
-
Check ur getNumber FUNCTION,
Do this:
REPLACE THIS "getNumber(P_NUMBER OUT NUMBER)" with
"FUNCTION getNumber RETURN NUMBER;"
in ur package header.
CREATE OR REPLACE PACKAGE tokenize
IS
TYPE tokentab IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
PROCEDURE setTokens(p_string VARCHAR2, p_delimiter VARCHAR2);
FUNCTION getToken(p_index PLS_INTEGER) RETURN VARCHAR2;
FUNCTION getNumber RETURN NUMBER;
PRAGMA RESTRICT_REFERENCES(getToken,WNDS,WNPS,RNDS);
END tokenize;
/
2)
Paste this in ur package body
REPLACE THIS "getNumber(P_NUMBER OUT NUMBER)"
FUNCTION getNumber
RETURN NUMBER
IS
V_TOTAL NUMBER;
BEGIN
V_TOTAL:=tokens.COUNT;
DBMS_OUTPUT.PUT_LINE('TOKEN COUNT' || V_TOTAL);
return V_TOTAL;
END getNumber;
INSTEAD of
REMOVE this "(p_number OUT NUMBER)"
FUNCTION getNumber
(p_number OUT NUMBER)
RETURN NUMBER
IS
V_TOTAL NUMBER;
BEGIN
V_TOTAL:=tokens.COUNT;
DBMS_OUTPUT.PUT_LINE('TOKEN COUNT', V_TOTAL);
return V_TOTAL;
END getNumber;
Cheers!
Cheers!
OraKid.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|