| PLS-00222 [message #118839] |
Mon, 09 May 2005 03:57  |
patrykp
Messages: 31
Registered: April 2005
|
Member |
|
|
Why does my function not compile?
CREATE OR REPLACE FUNCTION SA.TEST(
CurrUser_ID IN NUMBER DEFAULT NULL,
Object_ID IN NUMBER DEFAULT NULL,
Path_ID IN NUMBER DEFAULT NULL,
IsLastPhase IN NUMBER DEFAULT NULL,
NewPhase_ID IN NUMBER DEFAULT NULL,
User_ID IN NUMBER DEFAULT NULL,
Comment_ IN VARCHAR2 DEFAULT NULL,RC1_CALL IN OUT Omwb_emulation.globalPkg.RCT1 )
RETURN INTEGER
AS
CurrUser_ID_ NUMBER(10,0) := CurrUser_ID;
Object_ID_ NUMBER(10,0) := Object_ID;
Path_ID_ NUMBER(10,0) := Path_ID;
IsLastPhase_ NUMBER(3,0) := IsLastPhase;
NewPhase_ID_ NUMBER(10,0) := NewPhase_ID;
User_ID_ NUMBER(10,0) := User_ID;
Comment__ VARCHAR2(255) := Comment_;
StoO_selcnt INTEGER;
StoO_error INTEGER;
StoO_rowcnt INTEGER;
StoO_crowcnt INTEGER := 0;
StoO_fetchstatus INTEGER := 0;
StoO_errmsg VARCHAR2(255);
StoO_sqlstatus INTEGER;
tempVar1 NUMBER :=3;
tempVar2 NUMBER :=1;
id NUMBER(10,0);
CURSOR ptr IS
SELECT Object_ID
FROM TT_APPOBJECTS;
p NUMBER(10);
dummy_var1 INTEGER;
BEGIN
p:=sa.spCXDB_expandtree(SPCXDB_APPROVEPRJ.Object_ID_,
tempVar1,
tempVar2,
RC1 => RC1_CALL);
INSERT INTO TT_APPOBJECTS (object_id) values (p); EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
StoO_error := SQLCODE;
StoO_errmsg := SQLERRM;
raise_application_error(SQLCODE, SQLERRM,true);
END;
END SPCXDB_APPROVEPRJ;
PLS-00222: no function with name 'SPCXDB_EXPANDTREE' exists in this scope.
Best regards.
|
|
|
|
| Re: PLS-00222 [message #118859 is a reply to message #118839] |
Mon, 09 May 2005 07:18  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
You have no function sa.spCXDB_expandtree, or you do not have direct grants to it.
| Quote: |
CREATE OR REPLACE FUNCTION SA.TEST(
...
END;
END SPCXDB_APPROVEPRJ;
|
This will give you an error too. (Double end and names must match)
[Updated on: Mon, 09 May 2005 07:19] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
